G Guest Feb 23, 2006 #1 I want to insert records from one table into another from different dabases in VB6. The databses are all in Access
I want to insert records from one table into another from different dabases in VB6. The databses are all in Access
D Douglas J Steele Feb 23, 2006 #2 The syntax is: INSERT INTO target [IN externaldatabase] [(field1[, field2[, ...]])] SELECT [source.]field1[, field2[, ...] FROM tableexpression An example would be something like: INSERT INTO Table1 IN 'C:\My Documents\JetData.mdb' (Field1, Field2, Field3) SELECT FieldA, FieldB , FieldC FROM Table2
The syntax is: INSERT INTO target [IN externaldatabase] [(field1[, field2[, ...]])] SELECT [source.]field1[, field2[, ...] FROM tableexpression An example would be something like: INSERT INTO Table1 IN 'C:\My Documents\JetData.mdb' (Field1, Field2, Field3) SELECT FieldA, FieldB , FieldC FROM Table2
