merging data.

[Lee Taylor-Vaughan]

hello

I have a database where the users have been entering data in to 2 separate
mdb files. each mdb file has identical tables.

is there an easy way to merge all the information from one mdb to the other?

I tried doing a unmatch query, but when i try to cut and paste the data it
get an error because the data inthe other tables is linked via a primary key
(i.e. tblInvoice.ID = tblInvoiceDetail.ID). is there an easy workaround to
this?

thanks

Lee

 

[Jeff Boyce]

Lee

If there are any tables in the respective .mdb files that are related and
depend on the primary key ID#, attempting to combine will put your data
integrity in jeopardy. Your description implies this is the case. So, if
each database has been using autonumber IDs, you could have two "orders"
with the ID# = 17, right? If you were somehow able to add db2's records to
db1, to which #17 order do the order detail rows apply?!

If your description is accurate, you have orders and order details. If you
merge two separate "order" systems, how can you be sure that the same person
hasn't placed an order in each system? You'll need to figure out how you
would determine "duplicates" before you can tell Access how to.

While possible, it will take some work. Before you start, backup! Before
you start, perhaps you could describe why you thing you need to merge these.
Maybe the 'group readers could offer a different approach...