If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Merging of Two Databases
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 |
#3
|
|||
|
|||
Merging of Two Databases
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 |
#4
|
|||
|
|||
Merging of Two Databases
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 |
#5
|
|||
|
|||
Merging of Two Databases
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Merging 2 different access databases ?? | iamwhatiam | General Discussion | 4 | November 1st, 2005 07:20 PM |
Merging databases | DannyJ | General Discussion | 2 | May 10th, 2005 11:48 PM |
Merging Records from one table to another on different databases | Mike Smith | Running & Setting Up Queries | 3 | November 3rd, 2004 07:02 PM |
Merging Records from one table to another on different databases | Mike Smith | General Discussion | 5 | November 3rd, 2004 07:02 PM |
Merging Data from Several Database's into One | Tammy | General Discussion | 0 | November 3rd, 2004 02:46 AM |