SQL Server Performance

Could not find installable ISAM.

Discussion in 'SQL Server 2005 T-SQL Performance Tuning' started by andres_j, Sep 11, 2008.

  1. andres_j New Member

    Hi,
    I'm trying to build a stored procedure in order to import data from an excel file to a temporary table. I'm using the following code:set
    @strSql = 'SELECT * INTO #TempTable FROM OPENROWSET( "Microsoft.Jet.OLEDB.4.0", "Excel 12.0;Database=C:FileName.xls","SELECT * FROM [Sheet1$]") ' EXEC sp_executesql @strSql
    then when executing the code I get the following error:
    OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "Could not find installable ISAM.".
    Msg 7303, Level 16, State 1, Line 1
    Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".
    I'm using SqlServer 2005 and had already enabled the OPENROWSET command in the Sql Server Surface Configuration Area. What is wrong here?
    Thanks for helping.
    NOTE: The excel file DOES exist in C: drive location and it is closed. I'm working locally in my computer.
    andres_j, Sep 11, 2008
    #2

  2. satya Moderator

    Welcome to the forums.http://sql-server-performance.com/Community/forums/t/10004.aspx fyi and http://databases.aspfaq.com/database/how-do-i-solve-could-not-find-installable-isam-errors.html too.
    satya, Sep 12, 2008
    #3

  3. andres_j New Member

    Hi satya,
    thanks for your response.. I checked those both urls but I they did not help to solve he problem.. I'm using windows vista w/MS Office 2007. Any suggestions?
    andres_j, Sep 12, 2008
    #4

Share This Page