Results 1 to 5 of 5

Thread: In Access 2007 I need to combine multiple tables into 1 having identical fields

  1. #1
    Join Date
    Apr 2008
    Posts
    32

    In Access 2007 I need to combine multiple tables into 1 having identical fields

    Hello,

    I am working with Access 2007. I am fairly new with it.
    I need to combine multiple tables into 1 having identical fields into a single table.

    Is there any simple & easy way to do so?

  2. #2
    Join Date
    Jan 2009
    Posts
    39

    Re: In Access 2007 I need to combine multiple tables into 1 having identical fields

    You use an Append query. Make a structure only copy of one of the tables (use Copy and paste).
    Then add the identifier.
    Now run Append queries for each table into the new main table.

  3. #3
    Join Date
    Feb 2008
    Posts
    1,856

    Re: In Access 2007 I need to combine multiple tables into 1 having identical fields

    • Make a new empty table or choose the existing table to be the central repository of the data.
    • Make a query for all field and records for the first table. Change the query type to Append and select the destination table as the target.
    • Execute the query
    • Delete the source table and replace with the next
    • Repeat the procedure until all source tables have been used.

  4. #4
    Join Date
    Jan 2009
    Posts
    36

    Re: In Access 2007 I need to combine multiple tables into 1 having identical fields

    Hi
    You need to establish a relationship between the tables. This is really simple in Ms access. You can drag and drop fields from one table to the other to create the relationship.
    Code:
    SELECT TableA.PrjectNumber, TableA.DVD#, tableb.BobNumber
    FROM tableA INNER JOIN tableB ON TableA.ProjectNumber = TableB.ProjectNumber;
    http://office.microsoft.com/en-us/ac...963201033.aspx

  5. #5
    Join Date
    May 2012
    Posts
    1

    Re: In Access 2007 I need to combine multiple tables into 1 having identical fields

    You can also do a UNION select. SELECT * FROM TABLE1 UNION SELECT * FROM TABLE2 etc.

Similar Threads

  1. Combine 2 Pivot Tables into 1 Master Workbook?
    By DANIEL 602 in forum MS Office Support
    Replies: 1
    Last Post: 04-02-2013, 10:51 AM
  2. Replies: 6
    Last Post: 27-11-2011, 04:50 PM
  3. Replies: 7
    Last Post: 26-11-2009, 11:31 PM
  4. How to Automatically access the fields of an Access 2007 forms
    By Corona in forum Software Development
    Replies: 3
    Last Post: 25-06-2009, 12:54 PM
  5. Replies: 2
    Last Post: 24-11-2008, 04:48 PM

Posting Permissions

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