Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2006

    Unanswered: Combine access tables

    I need to combine five access tables - they all containe the same field names and have a different id number as the primary key - I would like to use the info from all of the tables for queries, etc...


  2. #2
    Join Date
    May 2005
    Can you run a Query to combine them into one? That should do it.
    Me.Geek = True

  3. #3
    Join Date
    Dec 2006
    From Access help:

    The following union query (union query: A query that uses the UNION operator to combine the results of two or more select queries.) selects all company names and cities from both the Suppliers and Customers tables, and sorts the data alphabetically by city.

    SELECT [CompanyName], [City]
    FROM [Suppliers]

    UNION SELECT [CompanyName], [City]
    FROM [Customers]
    ORDER BY [City];

Posting Permissions

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