How to fix the " 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. (System.Data)" error SQL Server Import and Export Wizard

Question

I have Microsoft SQL Server Management Studio and I am trying to import Excel files to work with in SQL. After choosing Microsoft Excel as the Data Source and choosing the file path, I get an error message saying that the operation could not be completed.

And as additional information, I am told that the 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. (System.Data)

How can I solve this? I have 64-bit system.

Please see the attached images for more information.

Answer 1

https://www.microsoft.com/en-us/download/details.aspx?id=54920 seems to be the place to go. Note that the error message says 16,0 not 12.0.

Answer 2

Hi @PACIFIQUE NTETA,

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 Hui

---

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