Im a newbie using vb.net pls help me
I would like to insert data from sql server to msaccess but i encountered some error in my sql command Thank you very much....
INSERT INTO OpenDataSource('Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\DENGUE.mdb;')... dengue (FIRSTNAME, AGEYEARS, REGION) SELECT FIRSTNAME, AGEYEARS, REGION FROM DENGUE
I would like to insert data from sql server to msaccess but i encountered some error in my sql command Thank you very much....
INSERT INTO OpenDataSource('Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\DENGUE.mdb;')... dengue (FIRSTNAME, AGEYEARS, REGION) SELECT FIRSTNAME, AGEYEARS, REGION FROM DENGUE