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
 
You must log in or register to reply here.

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL syntax 1
Access Access 2010 import/append data into table w/o overwriting existing records 0
Overwriting a table with another query 6
Appending data to linked tables 5
Access Click in Table to Open Form 0
Access 2010 append query to SQL is very slow 0
Append Query Issue 0
copying data from one dataset into another 3

Back
Top