Merging of Two Databases

K

kjmom57

I have two database files; exact same fields, etc. just with different data
that I need to merge together to form one database. One is a small file on
disk that was worked on at home and the other is the main file which is
worked on at the office. We need to update the work from home into the
office file. I need blow by blow directions on how to do this if possible.
I have never done this before.

Thanks Bigtime.
CJ
 
J

Jeff Boyce

Copy the home file onto your work PC.
Open your work file.
Go to the database window (user F11 if it isn't already there).
Click on the <Tables> tab.
Click on File | Get External Data
 
J

Jeff Boyce

Sorry for incomplete answer -- I found a new shortcut for sending!

....
after <Tables> tab
Click on File | Get External Data | Link... (from the menu bar).
Select the file from home.
Select the tables from your home copy that have records you want to add to
your work version.
Highlight one of the tables linked from your home copy.
Select the <query> choice from the drop down toolbar button.
Create an append query that copies fields from your home version to your
work version.
Repeat as needed for each table.
Delete the linked tables (this only deletes the link/connection to them from
your work version -- it does NOT actually delete the tables).

You're done.

Regards

Jeff Boyce
<Office/Access MVP>
 
J

Jeff Boyce

I don't understand. If the fields are not the same, what are you merging?

Regards

Jeff Boyce
<Office/Access MVP>
 
Top