This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 85%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEK%3C/text%3E%3C/svg%3E)
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?
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
Additional SQL Server features and topics not covered by specific categories
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
I answered this very question multiple times on this forum.
Please search for the existing answers. There are plenty of them.
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
Have you installed both 32bit and 64bit? Remember to restart the machine after the installation.
Hi @ZoeHui-MSFT ,
I have restarted the machine, I still get the error.....
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(156.8, 83%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECM%3C/text%3E%3C/svg%3E)
@Eric Klein Goldewijk I'm curious if you were able to resolve this, and what you did. I'm having the same problem, and the bountiful answers that Yitzhak Khabinsky graciously provided in his previous posts did not fix the issue for me either.
Hello Christopher,
@Yitzhak Khabinsky provided me with answers in a 1 on 1 contact, very helpull!
Greetings,
Eric
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.