Dynamic Field Name when Import into Access

Hello,

I have the following code. I am using it as part of a transport from excel to access database. The code works fine, but I would like the Field name "022007" to be read from a cell, rather than manually entering it. Simply because the field name changes all the time.

Please Login or Register  to view this content.

Is this possible, and It would be great if somebody could help me understand how?

Many thanks,

JC,

Hi

If you have 022007 in A1 then try

Please Login or Register  to view this content.

rylo

Works Perfectly. Thank you.!!