Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    May 2008
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Joining mulitple table (Access 2003)

    How do I join multiple tables together to create a new table and keep all entry from all tables? (All tables have the same columns and headers) For example, I have table A, table B, table C, ect... and I want to create Table Z with all data from table A, table B, table C, ect.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Joining mulitple table (Access 2003)

    1) Start creating a new query in design view, but don't add any tables.
    Select View | SQL.
    Type the following SQL statement, using the correct table names:

    SELECT * FROM [First Table]
    UNION ALL
    SELECT * FROM [Second Table]
    UNION ALL
    SELECT * FROM [Third Table]

    You can add more tables as needed.
    Switch to datasheet view to see if the query returns records.
    Then save and close the query.

    2) Create a new query in design view based on the query that you created in step 1).
    Add * from the field list to the design grid.
    Select Query | Make Table Query and specify the name for the new table.
    Select Query | Run to execute the make-table query.

  3. The Following User Says Thank You to HansV For This Useful Post:

    Tony Gater (2015-04-09)

  4. #3
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Joining mulitple table (Access 2003)

    You can do this 'manually' as well.

    Make a copy of tableA, and choose to copy just the structure. Call it TableZ.

    Now open each of the other tables one at a time. Select all the records then copy.
    Go back to TableZ and do Paste...Append.
    Repeat for each table.
    Regards
    John



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •