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:-
The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" could not find "installable ISAM."
Query that i used in the stored procedure:-
Expand|Select|Wrap|Line Numbers
- EXEC('SELECT * INTO temp FROM OPENROWSET(''Microsoft.Jet.OLEDB.4.0'',
- ''Excel 8.0;Database=' + @ba_bm_status + ''',' +
- '''SELECT * FROM [qry_BA_Controlling (Report)$]'')');
webserver used:- IIS, connection is through odbc.
I have no information about this error. Can you please help me in solving the same.