merging access data between multiple computers

L

Larry

How does one export data from an access db on one computer
to merge it with (add to) the access data on an identical
access db on a different computer.
 
K

Kevin @ 3NF

Append queries are probably the simplest way if your goal is to combine te
data. Linked tables if you just want it to be visible from one to the
other.
 
J

Joe Fallon

Right.
Whe you use Append queries and you get to the screen where you name a table:
STOP.

There is an option to choose another database!
(I can't tell you how many users don't see this!)

Click it and enter the path to the other .mdb.
Then pick the table in the other mdb!
 

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