How do I merge data from 2 identical databases?

  • Thread starter Thread starter FatBoy
  • Start date Start date
F

FatBoy

I have three databases, structures are all identical. There is supposed
to be only one database, but users have been entering data in all 3, so
all of them have different data. Is there a way to union the data in
the existing tables of all three into one master database?

I know next to nothing about MS Access.

Thanks!
 
I have three databases, structures are all identical. There is supposed
to be only one database, but users have been entering data in all 3, so
all of them have different data. Is there a way to union the data in
the existing tables of all three into one master database?

I know next to nothing about MS Access.

Thanks!
Click to expand...

Yes; but it may be easy, or may be very difficult. It depends on the
structure of the database and the nature of the data.

Do your tables have Autonumber primary keys? Are these linked to Long
Integer foreign keys in other tables? If so, then you'll have a fair
bit of hassle, since all three databases are likely to have records
with duplicate autonumbers. These will need to be resolved before you
can merge them.

I've done similar tasks in a few minutes, using File... Get External
Data... Link and running a few Append queries; and I've had to work
for days to resolve complete and partial duplicates. Just depends on
the specific situation!

John W. Vinson[MVP]
 
Back
Top