MS Access: Transfering Data from one DB to Another DB

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.

James CoatsComputer Info. Sys. StudentAsked:
Who is Participating?
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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.
James CoatsComputer Info. Sys. StudentAuthor Commented:
Thanks, LSM
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.