Last post Feb 10, 2012 05:51 AM by charly.p
Feb 07, 2012 06:16 AM|charly.p|LINK
Hello guys, I'm having troubel opening an connection to an excel file with the xlsx extension.
I'ts on an Ms server 2008 R2 64bit, where I installed the "Microsoft Access Database Engine 2010 Redistributable" to be able to access this file.
I'm getting the following error:
System.Data.OleDb.OleDbException: Could not find installable ISAM
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\Template.xlsx;Extended Properties="Excel 14.0 Xml;HDR=YES";
I thought the ISAM error only occured for xls files?
Do I need to install something else ?
Feb 10, 2012 05:51 AM|charly.p|LINK
I did change de the Extended Properties to Excel 12.0 and now it works.