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...