Appending records from one table to another

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
 
O

onedaywhen

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
 
Top