Excel Linked Server Problem

To All

I'm using the following code to create a Linked Excel server.

EXEC sp_addlinkedserver 'ExcelSource',

'Jet 4.0',

'Microsoft.Jet.OLEDB.4.0',

'\\schuette-dc\DriveH\Temp\EDI\CSCNEDI.xls',

NULL,

'Excel 8.0';

GO

--

The server create correctly, but when I try the following

SELECT * FROM ExcelSource...CSCN

I get the following error

-

[OLE/DB provider returned message: Unspecified error]

OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80004005: ].

Msg 7399, Level 16, State 1, Line 15

OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.

-

I have verified that i have full access to the "Temp" directory. I have even tried creating a "Named Range" in the spreadsheet with no success.

Thanks

David Davis

Tried on XP SP2 machine and it works fine for me. Try using OpenRowset and see if it works

select * from OpenRowset( 'Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=\\schuette-dc\DriveH\Temp\EDI\CSCNEDI.xls', 'select * from CSCN')

OpenRowset documentation: http://msdn2.microsoft.com/en-us/library/ms190312.aspx

OpenQuery documentation: http://msdn2.microsoft.com/en-us/library/ms188427.aspx

Also take a look at this : http://groups.google.com/group/microsoft.public.sqlserver.programming/browse_thread/thread/6fbf566977fe8504/5871e88b33c1445b?lnk=st&q=OLE+DB+error+trace+%5BOLE%2FDB+Provider+%27Microsoft.Jet.OLEDB.4.0%27+IDBInitialize%3A%3AInitialize+returned+0x80004005%3A+%5D.&rnum=8&hl=en#5871e88b33c1445b

Hope this helps

|||

Raj

I tried the statement and get the same error message.

Thanks

David Davis

|||Hi, anyone solved this problem yet?

My error is the same. I have seen many reports of this problem but no answers.

Thanks.