Error Help!!!!!!

I created a linked server to access information in an excel spreadsheet
by using this code:

exec sp_addlinkedserver N'LINKEXCEL_OL',
@srvproduct = N'',
@provider = N'Microsoft.Jet.OLEDB.4.0',
@datasrc = N'C:\dt.xls',
@provstr = N'Excel 8.0;'

I created a login using this code:

EXEC sp_addlinkedsrvlogin 'LINKEXCEL_OL', 'false'

and I tried to run a query using this code:

select * from openquery(LINKEXCEL_OL, 'select * from [Sheet1$]')


Everything is ok until the select when I get this very descriptive error(sarcasm):

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.].

Does anyone have any suggestions??? I am very lost and do nto see why this wouldn't work..

The problem may be in sp_addlinkedsrvlogin procedure. Drop your linked server login using sp_droplinkedsrvlogin and recreate it as

EXEC sp_addlinkedsrvlogin 'LINKEXCEL_OL', 'false', null, null, null

You should be fine after that. Also make sure that the excel sheet is not open when you query using SQL.

Appreciate for the answers!!

save my days of work...