November 26, 2009 at 11:58 pm
Dear all,
I am getting following error message while executing below statement in stored procedure
select * FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
'Excel 8.0;Database=E:\Motor\UploadCheques.xls;HDR=YES',
'SELECT FCRNo, [Payee Code],[Cheque No], [Cheque Date] FROM [Sheet1$]')
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: Unspecified error]
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80004005:
Error occurs after we applied indexing to our database. So before applying indexing it was working fine.
Thanks in advance.
November 27, 2009 at 1:08 pm
I don't think applying Indexes in your database caused that error.
If you feel so, have you tested it by dropping the indexes and run the SP?
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
November 28, 2009 at 12:33 am
Thanks for the reply.
We restarted the server and now its working fine.
December 1, 2009 at 6:05 am
Though our issue has been resolved, can anyone let me know what exactly caused the problem?
Also I would like to know, is there any alternate way to read excel file in SQL Server 2000 other than OPENROWSET()?
December 1, 2009 at 7:14 am
porwal.naveen (12/1/2009)
Though our issue has been resolved, can anyone let me know what exactly caused the problem?Also I would like to know, is there any alternate way to read excel file in SQL Server 2000 other than OPENROWSET()?
I believe you can setup and use linked server to read/write to an excel filw.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply