Merge Table Data in Microsoft Access 2000

Posted on 2007-08-06
Last Modified: 2013-11-27
I am trying to find a simple way to merge data that resides in two diferent acess tables that reside in one master database.

Table 1 has first name, last name, address

I need to get this data into table 2 that has the fields fname, lname, addr

Is there a simple way to do this without any major scripting?
Question by:isatonline
    LVL 92

    Accepted Solution

    Very easy:

    INSERT INTO table2 (fname, lname, addr)
    SELECT firstname, lastname, address FROM table1

    Author Comment

    can you tell me where I can add this in? I am not very experienced in access. Thanks for the quick response!
    LVL 17

    Assisted Solution

    in the query designer create a query that selects first name, last name, address from Table 1
    then in the toolbar select append query as the the query type and choose Table 2 as the destination table
    for each of the fields in the query select the destination field in the qbe grid

    LVL 92

    Expert Comment

    by:Patrick Matthews
    isatonline said:
    >>can you tell me where I can add this in? I am not very experienced in access. Thanks for the quick response!

    Go into the query designer, and change the view to SQL.  Paste my code in there, and
    edit table/field names to match what's in your db.

    If any table or field names have spaces or punctuation, you need to wrap them in brackets.
    LVL 1

    Expert Comment

    Forced accept.

    EE Admin

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
    Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

    794 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

    17 Experts available now in Live!

    Get 1:1 Help Now