How do I merge data from two databases into one?

[Guest]

Hello,

I have developed a database for recording data at different geographic
locations. How do I begin the process of joining the data together into one
master database? I believe they need to be synchronized somehow, but am not
sure how to begin the process. Any help would be greatly appreciated.

Thanks.

 

[John Vinson]

On Mon, 20 Dec 2004 07:41:05 -0800, New Access User <New Access

Hello,

I have developed a database for recording data at different geographic
locations. How do I begin the process of joining the data together into one
master database? I believe they need to be synchronized somehow, but am not
sure how to begin the process. Any help would be greatly appreciated.

Thanks.

This can be a very easy job - just use File... Get External Data...
Link Tables to link to the second database, and run an Append query to
combine the data from the tables into one.

Or it can be almost nightmarishly difficult, if your databases have
overlapping data, *almost* overlapping data, duplicate autonumbers,
foreign key fields linked to duplicate autonumber, etc. etc.

What's the nature of the tables? How many in each database? Do you
have Autonumber primary keys in the tables?

John W. Vinson[MVP]