Microsoft.ACE.OLEDB.12.0 missing with excel upgrade

Question

question

pri07-2793 asked Apr 28, '22 YitzhakKhabinsky-0887 edited Apr 28, '22

Microsoft.ACE.OLEDB.12.0 missing with excel upgrade

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.

I want to know how the excel upgrade is affecting the OLEDB.
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-scripts-excel-dev

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 1 · 2022-04-28T13:25:38.02Z

YitzhakKhabinsky-0887 answered Apr 28, '22 YitzhakKhabinsky-0887 edited Apr 28, '22

Hi @pri07-2793,

You can install Microsoft ACE OLEDB provider v.12.0 by yourself
It can coexist with v.16.0 on the same machine

Here is its download link: https://www.microsoft.com/en-us/download/details.aspx?id=13255

Here is a screen shot that shows how they are both installed on my machine.

ssms-oledb-providers.jpg (27.0 KiB)

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 2 · 2022-04-28T06:01:41.997Z

OlafHelper-2800 answered Apr 28, '22 pri07-2793 commented Apr 28, '22

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?

· 1

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

pri07-2793 · Apr 28 at 06:39 AM

Hi, Thanks for your reply. You are right, I could change it with "Search & Replace". Since it has to be changed in all modules, I wanted to find a way such that excel upgrade won't affect the existing OLEDB configuration. Can you please tell me what can be done to resolve this ?

0 ·

question