could not find Installable ISAM

[help_lucky]

Hi All,

 

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:-

 

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.

 

[dabaR]

Are you today using a different input file than you were yesterday? If so, can you try with the file that worked yesterday?

[help_lucky]

Today i have tried with a different input. surprisingly i am not able to upload with the last working excel file too.

[dabaR]

have there been any changes to the linked servers configuration?