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.
| Author |
Topic |
|
srucker
Starting Member
26 Posts |
 Posted - 2009-09-03 : 08:34:48
|
| I set up a linked server in SQL Server 2005 SP2 to access an Excel file. When I tried to query the file I encountered the following error:[OLE/DB provider returned message: Could not find installable ISAM.]OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80004005: ].Msg 7399, Level 16, State 1, Line 2OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. I verified that the dll (msexcl40.dll) was properly registered on the server.Might anyone have some insight?Thx in adv! |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-09-03 : 10:07:47
|
| How are you querying the file?Also, how did you set up the linked server? |
 |
|
|
srucker
Starting Member
26 Posts |
Posted - 2009-09-03 : 13:20:00
|
| Query from Mgmt Studio = SELECT * FROM TestLinkedServer...Sheet1$ I created a new linked server w/ the following properties:LinkedServer = TestLinkedServerProvider = MS Jet OLE DB ProviderProduct Name = ExcelDataSource = \\servername\C$\Test\Test.xlsProvider String = Excel |
|
|
|
|
|
|
MS JET OLEDB4.0 Error w/ Linked Server