Need to merge 3 mdb`s

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,Please can anyone tell me how to merge 3 mdb`s that i have made.The fields
all exactly the same.
 
add a linked table to the master database (the one you plan to keep) that
links back to the others. Then create an append query to grab all the
records from that linked table and insert them into your new master table.

Then, delete the links and delete the unneeeded files.

Rick B
 
Hi,Please can anyone tell me how to merge 3 mdb`s that i have made.The fields
all exactly the same.
Click to expand...

Rick's suggestion is right on - but just a warning! If your tables
have Autonumber fields, there may - nay, WILL - be conflicts where you
have the same autonumber value (perhaps linked to Long Integer foreign
key fields in other tables) in both or all three databases. You'll
need to come up with some *SAFE* logical way to resolve these
conflicts. This might be easy and it might be nightmarishly difficult
depending on your database structure and how far the autonumber-based
relationships penetrate.

John W. Vinson[MVP]
 
Thanks for the help but please can you explain in plain english as i am
computer stupid...Sorry
 
Thanks for the help but please can you explain in plain english as i am
computer stupid...Sorry
Click to expand...

You'll need to give us some help here, DJJohn. What is in these three
mdb files? How many tables? Do the tables have Autonumber fields
(makes a big difference)? How are the tables related?

John W. Vinson[MVP]
 
Back
Top