merging data.

  • Thread starter Thread starter Lee Taylor-Vaughan
  • Start date Start date
L

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
 
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...
 
your analagy of my situation is accurate.
I have backed up and have started the long and tedious process of
transfering the data.
I was thinking about writing some VB to handle this and post into the
correct table.

Thanks

Lee
 
Back
Top