Integration service and OLE DB provider Microsoft.ace.oledb.16.0 is not register

• matteo.veggiari

  SSC Enthusiast

  Points: 172

  More actions

  April 16, 2020 at 7:25 pm

  #3743563

  Hi to all. I'm in trouble.

  I want to create an Integration Service project in Visual Studio 2017. I've already installed Microsoft Access Database Engine 2016 Redistributable x64. So when I add a new Excel source type with an OLEDB connector Visual Studio tells me "OLE DB provider Microsoft.ace.oledb.16.0 is not registered".

  I tried to reinstall Microsoft Access Database Engine and upgrade Visual Studio 2017 but the problem persist.

  If can be useful, in my system there is Office 2019 x64.

  Please help me. Thank you very much

  Best regards

  Matteo

• frederico_fonseca

  SSCoach

  Points: 16251

  More actions

  April 16, 2020 at 7:36 pm

  #3743566

  Visual Studio is 32 bit - you need to install ACE x32 in order to be able to create new SSIS packages using it.