Importing one field with data

[cgilmour2]

Could someone tell me how to insert one column, or field, from one database
into another? It has to carry over the data in the field.

Thank you

 

[pietlinden]

Could someone tell me how to insert one column, or field, from one database
into another?  It has to carry over the data in the field.

Thank you

If the field is already defined, then you can link to the external
table, write an update query and then run it using

DBEngine(0)(0).Execute "update Query Name"