Microsoft.ACE.OLEDB.12.0 missing with excel upgrade

pri07 21 Reputation points
2022-04-28T05:30:54.117+00:00

I recently upgraded to Office 2019 from Office 2007. Previously, with Excel 2007, the connection string worked perfectly.

"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & strExcelPath & ";Extended Properties=""Excel 12.0 Xml;HDR=Yes;"";"

But, now with excel upgrade to 2019, this connection failed. and when I checked the registry editor, Microsoft.ACE.OLEDB.12.0 is not there. Only Microsoft.ACE.OLEDB.16.0 is present.

  1. I want to know how the excel upgrade is affecting the OLEDB.
  2. I can't change the connection string in all the code. So, I need a way to make sure the OLEDB.12.0 is not affected by Excel upgrade.

Can someone please provide me clarity on my doubts. Thank you

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,714 questions
0 comments No comments
{count} votes

1 additional answer

Sort by: Most helpful
  1. Olaf Helper 43,166 Reputation points
    2022-04-28T06:01:41.997+00:00

    I want to know how the excel upgrade is affecting the OLEDB.

    Because a version upgrade isn't only a "facelift", it brings new features and how could an older data provider know the new features? It can't.

    I can't change the connection string in all the code.

    Why can't you? Normally apps have the connection string as global setting in the config file, so one place to change.
    If you haven't used config, then "Search & Replace".

    And why haven't you tested the update with your app(s) before?