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.

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.

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?