Installable ISAM not found
- by lucky
I have a requirement in which i upload excel sheets to sql server database. The business logic is executed and display as reports in php. It is working fine till yesterday. Today i tried to upload excel files. It is throwing an error message stating:-
Translated version of it by me:-
The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" has not found "installable ISAM." . Return
This is the original message in german:-- [Microsoft][ODBC SQL Server Driver][SQL Server] OLE DB-Anbieter "Microsoft.Jet.OLEDB.4.0" für den Verbindungsserver "(null)" hat die Meldung "Installierbares ISAM nicht gefunden." zurückgeben.
Query that i used in the stored procedure:-
EXEC('SELECT * INTO temp FROM OPENROWSET(''Microsoft.Jet.OLEDB.4.0'',
''Excel 8.0;Database=' + @ba_bm_status + ''',' +
'''SELECT * FROM [qry_BA_Controlling (Report)$]'')');
@ba_bm_status - i/p parameter of srored procedure
qry_BA_Controlling (Report) - worksheet name
webserver used:- IIS, connection is through odbc.
I have no information about this error. Can you please help me in solving the same.