MS Access: Transfering Data from one DB to Another DB

Posted on 2011-04-20
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 84

    Accepted Solution

    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
    Thanks, LSM

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Suggested Solutions

    I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
    SQL Command Tool comes with APEX under SQL Workshop. It helps us to make changes on the database directly using a graphical user interface. This helps us writing any SQL/ PLSQL queries and execute it on the database and we can create any database ob…
    Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now