Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Appending records from one table to another
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Appending records from one table to another
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 -- "Mary Tate" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
appending worksheet records into 1 worksheet | Excel Worksheet Functions | |||
Create new excel table with filtered records from another table | Excel Worksheet Functions | |||
Appending Excel file to an Access table | Excel Programming | |||
Appending linked worksheets to new records. | Excel Programming | |||
Appending/Updating records | Excel Programming |