How do I merge data from 2 identical databases?

[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!

 

[Guest]

Use an append query.

 

[John Vinson]

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!

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]