Importing one field with data

C

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 :)
 
P

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 :)
Click to expand...

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"
 
Top