Hi friends
This is the first time I try to use “collection” of a ADODB.recordset eg rsTarget, so need some fast help.
Essentially I want to assign the fields (columns) in this rsTarget with respective data. I tried to use of two sets. (fld as adodb.field)
Set fld = rsTarget.Fields.Item(count)
Set fld = rsTarget.Fields.Item(Column(count))
Then I try to use following to assign
RsTarget!fld.name = “Data1”
It failed stating that there is no fld.name. Using column set, it state that there is no ‘column” function. How to do it right? Thanks mates. :)
Stuck at ADODB Collections
This is the first time I try to use “collection” of a ADODB.recordset eg rsTarget, so need some fast help.
Essentially I want to assign the fields (columns) in this rsTarget with respective data. I tried to use of two sets. (fld as adodb.field)
Set fld = rsTarget.Fields.Item(count)
Set fld = rsTarget.Fields.Item(Column(count))
Then I try to use following to assign
RsTarget!fld.name = “Data1”
It failed stating that there is no fld.name. Using column set, it state that there is no ‘column” function. How to do it right? Thanks mates. :)
