locked
Oledb error ISAM RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    User-384047847 posted

    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 ?

    Tuesday, February 7, 2012 6:16 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    User-384047847 posted

    FYI

    I did change de the Extended Properties to Excel 12.0 and now it works.

    Friday, February 10, 2012 5:51 AM