Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Feb 10, 2012 09:51 AM by charly.p
Member
348 Points
305 Posts
Feb 07, 2012 10:16 AM|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 09:51 AM|LINK
FYI
I did change de the Extended Properties to Excel 12.0 and now it works.
charly.p
Member
348 Points
305 Posts
Oledb error ISAM
Feb 07, 2012 10:16 AM|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 ?
charly.p
Member
348 Points
305 Posts
Re: Oledb error ISAM
Feb 10, 2012 09:51 AM|LINK
FYI
I did change de the Extended Properties to Excel 12.0 and now it works.