Home Forums SQL Server 2014 Development - SQL Server 2014 ACE.OLEDB.12.0' provider is not registered on the local machine RE: ACE.OLEDB.12.0' provider is not registered on the local machine

  • April 14, 2015 at 7:05 am

    #1790782

    niladri.primalink (4/13/2015)

    Hi Jeff,

    Thanks for your quick reply.

    The below link has helped me to solve my problems

    Thanks once again.

    Thanks for the feedback. That appears to be for Office 2007 and isn't the latest ACE driver. I don't believe it will work with XML based spreadsheets via the later versions of Office.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)