(3) three separate locations collecting data; need to consolidate

N

NFHRN

i have an MS Access database program loaded on (3) three separate laptops
gathering data; i need to consolidate all three into one database??
 
X

xRoachx

Based on the limited information provided it is difficult to provide an
answer. However, you can import the tables from 2 of the DBs into the 3rd,
or import all 3 into a new DB.

Once you get the tables into one DB, assuming you have the same table
structure for the data you want to consolidate, use Append queries to
consolidate your data.

NOTE -- Always backup your DB BEFORE making any changes.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top