Importing one field with data

  • Thread starter Thread starter cgilmour2
  • Start date Start date
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 :)
 
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"
 
Back
Top