I am making a little vb.net program to do some updates that my .mdb currently does when it starts. Currently I update some local tables of the .mdb from SQL server like this;
INSERT INTO "localMsAccessTable" ("localColumn1", "localColumn2", ...)
SELECT "sqlColumn1", "sqlColumn2", ...
FROM "sqlTable"The real one looks like this - "qrysptEmployee" is a SQL passthrough query.
INSERT INTO tbl_Employee ( wID, wshortname, wlastname)
SELECT qrysptEmployee.wID, qrysptEmployee.wshortname, qrysptEmployee.wlastname
FROM qrysptEmployee;I did not really want to do this row by row. So what object and what methods of this object can INSERT a dataset/datatable into a local access table?

G'd Evening Darbid,
In your query i see no WHERE criteria, so it seems like there is a batch insert not a row by row process. am i missing something?