Microsoft.ACE.OLEDB.12.0 provider is not registred problem still nog fixed

Question

I have build a solution in SSIS (Visual Studio 2019) that takes data from an Excel file and upload it in a SQL server table (Microsoft SQL Server 2019).

When I execute the solution, every thing goes fine.

But when I deploy the solution to SQL and excecute the solution within a Job, I get the Microsoft.ACE.OLEDB.12.0 provider is not registred.

I have installed and re-installed both Microsoft Access Databse Engine 2010 Redistributalbe and Microsoft Access Database Engine 2016 Redistributable. I have toggeld the Run64BitRuntime and checked the TargetServerVersion....nothing seems to work.

I have no idea what to do next?

Answer 1

Hi @Eric Klein Goldewijk ，

Microsoft.ACE.OLEDB.12.0 provider is not registered

From the error message, it seems to be a 32bit vs 64bit issue.

Check installing-the-microsoft-ace-oledb-12-0-provider-for-both-64-bit-and-32-bit-processing, you may install both 32bit and 64bit provider.

Microsoft Access Database Engine 2010 Redistributable

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

I have installed the AccesDataBaseEngine, both 12 and 16, I can see them in the registry. But it is still not working....

Are there anymore options?

Regards,

Eric