none
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

    Question

  • Hi All,

    I'm developing a package on the development server to load data from Excel. I created excel connection manager and when i tried to use the 'Excel Source' in the dataflow task. I'm getting the following error:

    The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.

    What i did was i downloaded and installed the drivers from the following link

    http://www.microsoft.com/en-us/download/details.aspx?id=13255

    I restarted the server and still i'm getting the same error, can anyone please point where i'm going wrong? Have i downloaded the wrong set of drivers/

    Server Information:Windows Server 2008 R2,SP1

    Thanks

    Tuesday, May 14, 2013 11:03 AM

Answers

  • Thanks Russ and Koen i downloaded for 64 bit OS, so should i now download the drivers for 32 bit instead?

    Yes. BIDS is a 32-bit application, so you need the 32-bit providers installed in order to develop a package.

    MCSA SQL Server 2012 - Please mark posts as answered where appropriate.

    • Marked as answer by PMunshi Tuesday, May 14, 2013 1:18 PM
    Tuesday, May 14, 2013 12:21 PM

All replies