Hi, This can be done in the following manner in SQL query analyzer. --------------------------------------------------------------------- BEGIN CODE -- option 1 INSERT INTO sqltable (field1, field2, field3) SELECT FIELD2, FIELD2, FIELD3 FROM OPENDATASOURCE( 'Microsoft.Jet.OLEDB.4.0', 'Data Source="c:\accessfile.mdb"; User ID=Admin;Password=',tablename) -- option 2 INSERT INTO sqltable (field1, field2, field3) SELECT FIELD2, FIELD2, FIELD3 FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','c:\accessfile.mdb';'admin';'', tablename) END CODE --------------------------------------------------------------------- You may try the same thing using VB.Net. I hope this helps :).
Regards, John Adams ComponentOne LLC