Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Importing problem

Author  Topic 

hotshot_21
Yak Posting Veteran

97 Posts

Posted - 2006-01-06 : 04:10:43
i am tryimg to import access file to sql.the query is
SELECT *
INTO Randomeg
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Database="D:\emaildb;','SELECT * FROM test')

the error iam getting is
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
[OLE/DB provider returned message: Could not find installable ISAM.]

tried searching for jet drive 4.0 as well in registries and the files for 3.5,2.5 are there.
any suggestion whats is goign on.

shallu1_gupta
Constraint Violating Yak Guru

394 Posts

Posted - 2006-01-06 : 04:43:07
refer
http://support.microsoft.com/default.aspx?scid=kb;en-us;818182
Install Latest Service Pack for the Microsoft Jet 4.0 Database Engine
Go to Top of Page

hotshot_21
Yak Posting Veteran

97 Posts

Posted - 2006-01-06 : 04:51:24
iam using SP2 .and whenever i try to install jet drive it says
that "service pack version of this system is newer than update you are applying.there si no need to install this update"
Go to Top of Page

hotshot_21
Yak Posting Veteran

97 Posts

Posted - 2006-01-06 : 05:01:38
quote:
Originally posted by hotshot_21

iam using SP2 .and whenever i try to install jet drive it says
that "service pack version of this system is newer than update you are applying.there si no need to install this update"

i have jet version 4.08618.0
Go to Top of Page

gongxia649
So Suave

344 Posts

Posted - 2006-05-09 : 21:47:31
same problem here?
how do i fix it
Go to Top of Page
   

- Advertisement -