Stuck at ADODB Collections

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