merging 2 access database

  • Thread starter Thread starter bimosekin
  • Start date Start date
B

bimosekin

How can I merge the contents of two access database, while
at the same time resolving any primary-key conflicts. I
want only the contents of old-database to be merged with
the new-database, without transferring the tables.

Thanks,
bimosekin
 
How can I merge the contents of two access database, while
at the same time resolving any primary-key conflicts. I
want only the contents of old-database to be merged with
the new-database, without transferring the tables.
Click to expand...

You can use File... Get External Data... Link to link to the database
from which you wish to merge, and then run Append and Update queries.
It'll be tedious and require careful thought - Access has no way of
knowing how to resolve primary-key conflicts; you'll need to provide
that logic yourself in some manner.
 
Back
Top