openrowset works in sql 2005 but not Works in SQL 2000

Hi ,

I have Installed both SQL 2000 & SQL 2005 in my server

i have run a Query with open rowset Works in SQL 2005 but not Works in SQL 2000

My Query is Follows,

SELECT * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 5.0;Database=E:\FLB10607.XLS', 'SELECT * FROM [FLB10607$]')


in sql 2000 it shows the below error
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.]
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80004005: ].

re: openrowset works in sql 2005 but not Works in SQL 2000

Can your SQL 2000 see your excel file? Can you do a dir E:\FLB10607.XLS on your SQL 2000 and check if your server can see your file?


Good luck!!!

--- CK