Merging of Two Databases

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

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
"kjmom57" wrote in message
...
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

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

"kjmom57" wrote in message
...
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

Dear Mr. Boyce,
Do you know how to merge databases if the fields are not the same?
--
knuble07


"Jeff Boyce" wrote:

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

"kjmom57" wrote in message
...
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

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

Regards

Jeff Boyce
Office/Access MVP

"HaLevi" wrote in message
...
Dear Mr. Boyce,
Do you know how to merge databases if the fields are not the same?
--
knuble07


"Jeff Boyce" wrote:

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

"kjmom57" wrote in message
...
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