Computing.Net > Forums > Database > Merging DB's in Access

Merging DB's in Access

Reply to Message Icon

Original Message
Name: mmh
Date: May 4, 2006 at 15:55:10 Pacific
Subject: Merging DB's in Access
OS: XP
CPU/Ram: Pentium
Model/Manufacturer: Dell
Comment:

I have two databases. Very simple databases, basic data entry, no links to tables or formulas or anything of the sort. Some employees were entering data into db and others into another. Some were entering in both. I need to merge the tables so that all the info is contained in one. I am a novice at Access.


Report Offensive Message For Removal


Response Number 1
Name: jhunt303
Date: May 5, 2006 at 03:16:50 Pacific
Reply: (edit)

In the database window you shyould see Tables, Queries, Forms etc. Click Queries -> "Create new query in Design View", add both of your tables (the key fields should link for you) You should see two boxes (one for each table) with all the fields in. Double click on the fields you want.
-IMPORTANT - change the query type to MAKE_TABLE QUERY (under query) then hit the button in the top left to view the results, if they are ok, close the query window and save the query. Run the query and it should prompt you to create a new table, say yes and there you go!


Report Offensive Follow Up For Removal







Use following form to reply to current message:

   Name: From My Computing.Net Settings
 E-Mail: From My Computing.Net Settings

Subject: Merging DB's in Access

Comments:

 


  Homepage URL (*): 
Homepage Title (*): 
         Image URL: 
 
Data Recovery Software




Have you ever used OpenOffice?

Yes, as my main suite.
Yes, occationally.
Yes, but only once.
No, never.


View Results

Poll Finishes In 6 Days.
Discuss in The Lounge