January 23, 2012 at 10:27 am
Hello Guys, i'm try using this command:
INSERT INTO OPENROWSET('Microsoft.ACE.OLEDB.12.0',
'Excel 14.0;Database=C:\bd1.xlsx;',
'SELECT result1, result2 FROM [tbl$]')
SELECT result1,result2
from tbl
but, i've this:
"Could not find installable ISAM.".
OLE DB provider "Microsoft.ACE.OLEDB.12.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.ACE.OLEDB.12.0" for linked server "(null)".
I am running SQL Server 2008 r2 64-bit on Windows Server 2008 64-bit. I have installed Office 2010 and AccessDatabaseEngine_X64.exe available from
I have tried reinstalling the ACE drivers and restarting the server. I am now slowly losing the will to live..
Please can someone help me? Any suggestions welcome..
January 23, 2012 at 10:49 am
I believe that openrowset is read only. You can try using opendatasource. http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/2277719c-2484-4020-9b79-a0acb6f296e6/
Jared
CE - Microsoft
January 23, 2012 at 10:51 am
maybe not..
November 23, 2018 at 8:03 am
Sorry I know this was 6 years ago but the issue still exists in 2018 with Excel 2013 / 2016 and SQL Server 2012 / 2014
To cut the story short, the solution should be:
INSERT INTO [MyTable]
SELECT [Column1], [Column2] FROM OPENROWSET ( 'Microsoft.ACE.OLEDB.12.0',
'Excel 12.0 XML; Database=X:\MyFolder\MyExcelFile.xlsx; HDR=YES; IMEX=1 ',
'SELECT * FROM [MySheet1$] ' )
The ISAM error in the message "Could not find installable ISAM.". refers to the unsupported Excel File type."Excel 14.0"
Even if you install the 2017 "Microsoft Access Database Engine 2016 Redistributable" https://www.microsoft.com/en-us/download/details.aspx?id=54920
(32-bit "AccessDatabaseEngine.exe" for older Office or 64-bit "AccessDatabaseEngine_X64.exe" for SQL Servers or even PC/Clients with both 64-bit SQL Server & 64 bit Office e.g. 2016 or 365 ProPlus )
And on the download page above, if you open the "Install Instructions", although you can use either “Microsoft.ACE.OLEDB.12.0” or “Microsoft.ACE.OLEDB.16.0”
You still need to specify the Extended property for the file type you are using as "Excel 12.0 XML" which was Excel 2007 but supports Excel 2010, 2013 & 2016 (365?)
File Type (extension) ______________________ Extended Properties
Excel 97-2003 Workbook (.xls) ______________ Excel 8.0
Excel 2007+ Workbook (.xlsx) ______________ Excel 12.0 XML
Excel 2007+ Macro-enabled Workbook (.xlsm) _ Excel 12.0 Macro
I tested and if you use a later type such as "Excel 14.0" as in Office 2010 or "Excel 15.0" for Office 2013 or "Excel 16.0" for Office 2016 you will get the message "Could not find installable ISAM."
Basically, it looks like the XML format (as in the last X of xlsX) has not been changed since Excel 2007 when uploading basic values from an Excel Spreadsheet so use "Excel 12.0 XML"
For more code needed & info regarding "Configuration Steps for Excel Data Import to SQL Server",
please refer to https://www.excel-sql-server.com/excel-import-to-sql-server-using-distributed-queries.htm#ConfigurationStepsforExcelDataImporttoSQLServer
Alain
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply