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.

.Fields("022007") = Range ("N" & R) .Value
Is this possible, and It would be great if somebody could help me understand how?

Many thanks,

JC,