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