none
Connect to xlsx file

    Question

  • Environment

    Windows Server 2008 R2

    SQL Server 2008 R2 - (EE)

    I need to connect to excel 2007 files. I downloaded the Microsoft Access Database Engine 2010 Redistributable from this link

    http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=13255

    I installed the 32 bit to develop. I am able to design the package and run the package.

    I deployed the package where I installed the 64 bit version of the Microsoft Access Database Engine 2010 on similar environment.

    Now when I run the package I get error Microsoft.ACE.OLEDB.12.0 is not registered. and the acquire connection method failed.

    Thanks

    Dharmbir

    Friday, April 20, 2012 9:34 AM

Answers

All replies