Hi all,

I am trying to use the follwoing SQL in my VB app which uses the DE;

INSERT INTO TableB ( Field1, Field2) IN dbServer
SELECT Field1, Field2
FROM TableA;

where dbServer is the path parameter for TableB.

I keep getting a syntex error and have tried using a second variable dbServerB variable as:

dbServerB = " ' " & dbServer & " ' "

and using dbServerB in the SQL.

I have set the parameter property to adBSTR.


Any solution would be much appreciated.

Many Thanks

Jack