Installable ISAM not found
Posted
by lucky
on Stack Overflow
See other posts from Stack Overflow
or by lucky
Published on 2010-06-10T10:15:41Z
Indexed on
2010/06/10
10:43 UTC
Read the original article
Hit count: 886
php
|sql-server
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.
© Stack Overflow or respective owner
