INSERT INTO from 2 different DB sources 1

[phiberdelic]

In a nutshell I have 1 table inside Access (AccessTable), and one table inside SQL server (SQLTable). I am connected to the SQL DB via ODBC connection and I want to pull the matching data from the SQL table into my Access table, but I get a syntax error. When I create "AccessTable" on the SQL DB this statement runs fine (very slow but fine). If I connect to the SQLTable using Get Link Table, this statement works fine...however I can't edit linked tables. Please Help!!!

"INSERT INTO AccessTable SELECT Vendor, ProductID FROM SQLTable WHERE SQLTable.Vendor='03'"

 

[essnrv]

db should be set to SQL database and replace App.Path & "\dbName.mdb" with your access db path and name.
"Insert Into Accesstable IN '" & App.Path & "\dbName.mdb" & "' Select * from SQLTable where sqltable.vendor=3" Please remember to give helpful posts the stars they deserve!
This makes the post more visible to others in need!