is there any method in vb.net to import .mdb and .xls file into sql without using DTS or BCP.
iam trying to use the query.
SELECT *
INTO importintotable
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Database="D: \emaildb;','SELECT * FROM test')

but i get error saying
OLE/DB provider returned message: Could not find installable ISAM.

i checked the registry as well and in jet4.0 there is no file is that the error.

if u have other method to transfer please let me know or give me sample code.