Access 2003 Merge dbs

S

SA

Jime:

Generally, sure, open one of the dbs and use File -> Get External Data ->
Link Tables and link one db's tables to the other and then use an append
query to append the data from one table into the next, then simply drop the
links. Of course be sure that you've got unique records or that your
tables have an index that would forced duplicate records to be dropped.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top