By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,766 Members | 1,295 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,766 IT Pros & Developers. It's quick & easy.

openrowset works in sql 2005 but not Works in SQL 2000

P: 12
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: ].
Nov 9 '09 #1
Share this Question
Share on Google+
1 Reply

Expert 2.5K+
P: 2,878
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
Nov 9 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.