Microsoft.ace.oledb.12.0 provider is not registered for VS 2022 and run64bitRuntime disabled

Question

I recently upgraded my sql server from 2019 to 2022.

And also start to use Visual studio 2022.

Because there is some excel destination or source file in the SSIS package,

I got some errors like Microsoft.ace.oledb.12.0 provider is not registered.

I see the VS is 64bit version, and in the configuration property-debugging- Run64bitRuntime is set to true, and you cannot change to false for VS 2022.

What should I do in order to run it in VS for SSIS package that has excel file source or destination in it?

Thanks,

Answer 1

Hi @Anne,

As you correctly wrote in your question, the VS2022 is a 64-bit application. As such, it can use 64-bit drivers only. Including Microsoft ACE OLEDB Provider drivers (12.0, 15.0, or 16.0). All of them could be installed in parallel.

It is very easy to check what OLEDB drivers are installed via a .udl file.

Here is how to do it:

1. Create a text file on the file system with the extension .udl
2. Right mouse click on it, and select Properties option.
3. Click on the Provider tab, and you will see all 64-bit OLEDB drivers that are installed on your machine. Please see below what to expect. The screen shot shows that two versions of the 64-bit Microsoft ACE OLEDB Provider drivers (Microsoft Office 12.0/16.0 Access Database Engine OLE DB Provider) are installed: 12.0 and 16.0
4. If needed 64-bit OLEDB driver is not enlisted, you just need to download and install it.

Download links:

• Microsoft.ACE.OLEDB.12.0: https://www.microsoft.com/en-us/download/details.aspx?id=13255
• Microsoft.ACE.OLEDB.15.0: https://www.microsoft.com/en-us/download/details.aspx?id=39358
• Microsoft.ACE.OLEDB.16.0: https://www.microsoft.com/en-us/download/details.aspx?id=54920

Answer 2

Can you change the references to Microsoft.ACE.OLEDB.16.0 instead? (And of course, make sure it's installed first).

Answer 3

If you want to use the ACE data provider, you have to install it.

Microsoft Access Database Engine 2016 Redistributable

Answer 4

Hi @Anne,

Please try to install both 32bit and 64bit Microsoft Office.

Check How to install 64-bit Microsoft Access database engine alongside 32-bit Microsoft Office

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.