>I have the following statement that seems to work fine in native VFP, but when trying to run from VB6, it gives a syntax error. Any ideas?
>
>INSERT INTO Table1 (field1, field2, field3, field4) SELECT field1, field2, field3, field4 FROM Table2

I don't think ODBC driver supports that syntax (valid only in VFP8 and after). Try VFPOLEDB.
Cetin