Errors in compiling procedure having statment INSE

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

Errors in compiling procedure having statment INSE

Author

Topic

skbommi
Starting Member

2 Posts

Posted - 2009-07-13 : 04:28:03

Hi,

I have a stored procedure to get data from the database and show in an excel file. I have a job which does this. This uses same the excel file daily (daily the file is updated with new data).

I have changed the procedure to include new columns, and i also modified the excel file (for columns headers) but then the stored procedure is not being compiled since then.

I am using the below query. Database server is sql 2000, and excel 2003

INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=\\10.238.118.4\BTFiles1\Enhanced_TAT_Report_Folder\EnhancedTATreport.xls;HDR=YES;', 'SELECT * FROM [Sheet1$]')

I am getting the below error message

Server: Msg 7399, Level 16, State 1, Procedure sp_Enhanced_TAT_Report_Test, Line 196
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.].

Here i am not able to fix the error. Can any one please help me solving my problem. Thanks in advance.

rajdaksha
Aged Yak Warrior

595 Posts

Posted - 2009-07-13 : 06:22:32

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=53340

-------------------------
R..