How do I merge data from two databases into one?

A

AccessNewUser

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.
 
G

GettingIrritated

Just import the tables into a new database and then you can link the tables.
You can then manage the links by going to Tools, Database Utilities, Linked
Table Manager. Hope this helps!
 
G

Guest

Are you interested in combining your data into one table?
If so, you could start out by importing the data into a
new database (into separate tables, under different
names). Do this by clicking File, Get external Data,
Import. Then create an append query to append all the data
from the different tables into one table. This works on
the assumption that you have the same field names and so
forth in each table.

If you have several different tables that you want to keep
separate, just import them into the new database and don't
do the append.
 
Top