insert data into mdb by loop through the field name

i export the excel data into mdb database using the follow code, it works fine

Please Login or Register  to view this content.

I wish to make a loop because i have unlimited of same FieldName type.
Here i replace the field name with a string (CO1), try to loop the data and insert into database but failed.

Please Login or Register  to view this content.

The error is

Run-time error '3265'
Item can't be found in the collection corresponding to the requested name or ordinal

How to do that, thank guys
regards,
kimyap

Hi

You need to use an alternatiove syntax:

Please Login or Register  to view this content.

Richard