I need to update a table in my database from a table in another database; is there a way I can use a macro to do this?
I need to update a table in my database from a table in another database; is there a way I can use a macro to do this?
The easiest thing to do is probably to add the table from the other db as a "linked table" in your MDB file. This will allow you to reference the linked table as if it were a physical file in your MDB.
To link a table from an external db, select File|Get external data|Link tables, and then use the linked table wizard.