Appending records from one table to another

  • Thread starter Thread starter Mary Tate
  • Start date Start date
M

Mary Tate

Iam new at VB. I am in VB and using the VB data manager.
What would be the correct SQL statement to take all the
records from one table to append them to another table?
I have a dataset with 5 tables.

Any help would be GREATLY appreciated!

Mary
 
INSERT INTO
MyMainTable
(Col1, Col2, Col3)
SELECT
ColA AS Col1, ColB AS Col2, ColC AS Col3
FROM
Table1
UNION
SELECT
ColX AS Col1, ColY AS Col2, ColZ AS Col3
FROM
Table2
UNION
...
FROM table5
 
Back
Top