Combining Tables

Discussion in 'Microsoft Access Database Table Design' started by Bill, Apr 16, 2004.

  1. Bill

    Bill Guest

    I have 3 tables with similar data. What's the best way
    to combine them into one table?
     
    Bill, Apr 16, 2004
    #1
    1. Advertisements

  2. Bill

    DDM Guest

    Bill, look up "Append Query" in Access help. Do an append query to add
    records from Table B to Table A, then one to add the records from Table C.

    DDM
    "DDM's Microsoft Office Tips and Tricks"
    www.ddmcomputing.com

    "Bill" <> wrote in message
    news:002701c423ec$38257750$...
    > I have 3 tables with similar data. What's the best way
    > to combine them into one table?
     
    DDM, Apr 16, 2004
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Tim Das

    Combining many tables into one large table

    Tim Das, Jul 28, 2003, in forum: Microsoft Access Database Table Design
    Replies:
    0
    Views:
    485
    Tim Das
    Jul 28, 2003
  2. Matt

    Combining Tables

    Matt, Oct 7, 2003, in forum: Microsoft Access Database Table Design
    Replies:
    2
    Views:
    139
    Guest
    Oct 10, 2003
  3. Peter

    Combining tables

    Peter, Dec 6, 2003, in forum: Microsoft Access Database Table Design
    Replies:
    2
    Views:
    167
    Guest
    Dec 6, 2003
  4. Rose

    Combining tables

    Rose, May 17, 2004, in forum: Microsoft Access Database Table Design
    Replies:
    2
    Views:
    134
  5. Leigh

    combining tables

    Leigh, Sep 3, 2004, in forum: Microsoft Access Database Table Design
    Replies:
    0
    Views:
    179
    Leigh
    Sep 3, 2004
Loading...

Share This Page