Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

How to merge 2 identical tables ?

Discussion in 'Information Technology' started by Will, Jul 28, 2006.

  1. Will

    Will
    Expand Collapse
    Guest

    I have two identical tables... all fields are the same...

    tblOne
    id
    name
    city
    state

    tblTwo
    id
    name
    city
    state

    I want to merge the data into a single table.
    Both tables are in the same access database.

    How do you do this?

    thanks for any help.
     
  2. Loading...


  3. xRoachx

    xRoachx
    Expand Collapse
    Guest

    Hi Will -- Use an Append Query...

    "Will" wrote:

    > I have two identical tables... all fields are the same...
    >
    > tblOne
    > id
    > name
    > city
    > state
    >
    > tblTwo
    > id
    > name
    > city
    > state
    >
    > I want to merge the data into a single table.
    > Both tables are in the same access database.
    >
    > How do you do this?
    >
    > thanks for any help.
    >
    >
    >
     

Share This Page