MS Access: Transfering Data from one DB to Another DB

Posted on 2011-04-20
Medium Priority
Last Modified: 2012-06-27
Thanks to the many suggestions and improvements from the EE community I now have a new design for a db that holds the results of precision instrument checks and then shows the results of those checks that allows one to see the accuracy of the instruments.

I am now moving on the developing forms and queries to present those checks. I have provided a copy of the old db and the new improved db.

I want to transfer some of the data to the new db but I am not sure how to proceed or if I should do it at all and just start over with manual enteries.

I guess I will need to at least put in the "tool Descriptions" to start off with.

I would like some suggestions.

Question by:James Coats
LVL 85

Accepted Solution

Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 total points
ID: 35435243
You can use INSERT queries to move data from one table to another. The simplest way is to link the tables from DB_A into DB_B, then build INSERT queries in DB_B. Add both "Tool Description" tables to the query gird, then change the query type to INSERT. Add the fields from the table containing the data, then select which Table in DB_B you'll be inserting into. You can define exactly which field in TableA is to be moved into TableB, then "run" the query.

Author Closing Comment

by:James Coats
ID: 35435547
Thanks, LSM

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, I’ll look at how you can use a backup to start a secondary instance for MongoDB.
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question