Linked Server Accessing an Open Excel Spreadsheet

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)

Linked Server Accessing an Open Excel Spreadsheet

Author

Topic

Dave1500
Starting Member

3 Posts

Posted - 2008-10-29 : 11:47:52

Hi

Using SQL Server 2000 and Excel 8.0 (2002) I have created a linked server
which successfully extracts data from a closed spreadsheet. However the spreadsheet
is left open on the remote server as there is a frequent refresh process in
operation. When I attempt to link to the open spreadsheet I get the following
error message:

Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. The provider
did not give any information about the error.
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0'
IDBInitialize::Initialize returned 0x80004005: The provider did not give any
information about the error.].

Is there a way round this? Is it possible to link to an open spreadsheet or
must the file be closed when linking? Are there any possible workarounds or
alternative strategies for this?

Thanks in advance,
Dave

hanbingl
Aged Yak Warrior

652 Posts

Posted - 2008-10-29 : 14:18:47

http://support.microsoft.com/default.aspx?scid=kb;en-us;890759