Updating from a different database.

[Buster49]

I have a table in a master Access database. I want to open a series of other databases in turn and add to/update the contents of the master table with the contents of a similar table in each other database. I use ADO to make the connections. Can this be done using a SQL command? If so, how?

 

[PHV]

Something like this ?
SELECT columnlist FROM tablelist IN externaldatabase

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244