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;
The real one looks like this - "qrysptEmployee" is a SQL passthrough query.
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?
Code:
[COLOR=green][B]INSERT INTO "localMsAccessTable" ("localColumn1", "localColumn2", ...)
SELECT "sqlColumn1", "sqlColumn2", ...
FROM "sqlTable"[/B][/COLOR]
Code:
INSERT INTO tbl_Employee ( wID, wshortname, wlastname)
SELECT qrysptEmployee.wID, qrysptEmployee.wshortname, qrysptEmployee.wlastname
FROM qrysptEmployee;