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
 SQL Server 2000 Forums
 SQL Server Development (2000)
 OLE DB provider 'Microsoft.Jet.OLEDB.4.0'

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-07-12 : 09:26:55
maria writes "Hi all,

can anyone help with this? we have a linked server set up on a SQL7
machine which is using Microsoft Jet 4.0 OLE DB and connection to an
Excel Spreadsheet locally on the server. The provider string is Excel
5.0. this connection has been working for months, until today. it just
doesn't work anymore, and when you try to connect to it via QA using a
select query (which has always worked in the past it gives this error
message:

Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
[OLE/DB provider returned message: Could not find installable ISAM.]

Any ideas?

Thanks

------------------
Maria Bermudes - DBA
Entergy Trading, London UK
------------------"

sherrys
Starting Member

37 Posts

Posted - 2002-07-12 : 11:37:33
Here's what Microsoft has to say about that.

http://support.microsoft.com/search/preview.aspx?scid=kb;en-us;Q306397

Good Luck!

Go to Top of Page
   

- Advertisement -