How to fix SSMS Import Excel Microsoft.ACE.OLEDB.16.0 provider is not registered error

Question

I got a new laptop at work, and after installing SSMS (old and new versions), when I try to use the import wizard to import from an Excel spreadsheet, I get the error message The Microsoft.SCE.OLEDB.16.0 provider is not registered on the local machine. I google'd and one site said to install MDAC tools, so I did, but still got the error. I found another site that said to install ACCESSDBENGINE.exe or ACCESSDBENGINE_X64.exe, and had to install the X64 version because apparently my Office install is X64.

Answer 1

Hi @Patricia Ortiz,

Seems like 32bit vs 64bit issue.

You may try to install both 32bit and 64bit driver.

https://datasavvy.me/2017/07/20/installing-the-microsoft-ace-oledb-12-0-provider-for-both-64-bit-and-32-bit-processing/

https://www.microsoft.com/en-us/download/details.aspx?id=54920

Regards，

Zoe Hui

---

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

Answer 2

Hi @Patricia Ortiz,

one site said to install MDAC tools, so I did

No need to do that.

If you are launching the SQL Server Import and Export Wizard from SSMS, it is running DTSWizard.exe. And it is 32-bit application.

The only software you need is Microsoft ACE OLEDB Provider 16.0

It comes in two editions: 32-bit and 64-bit.

If you need to install ACE 32-bit edition, please open a command prompt as Administrator and launch the following:

c:\>AccessDatabaseEngine.exe /quiet

It will allow you to install both Microsoft ACE OLEDB Provider editions in parallel.