|
Subject:
|
importing files
|
|
Posted By:
|
hotshot_21
|
Post Date:
|
1/5/2006 5:34:08 AM
|
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.
|
|
