Merge Data from 2 tables

Results 1 to 2 of 2

Thread: Merge Data from 2 tables

  1. #1
    Join Date
    Dec 1969

    Default Merge Data from 2 tables

    Is there anyway to merge info from 2 fairly similar tables into a third table? Basically, I want to add info from table1 followed by the same type of info from table2 into table3. Thanks in advance.

  2. #2
    Eddie Campbell Guest

    Default RE: Merge Data from 2 tables

    Well why not just run two append queries, one from table1 and 1 from table2 ?<BR><BR>Or, and I&#039;m not sure if this is supported, run 1 append query using a UNION query to output table1 & table2 together.

Posting Permissions

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