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

Patricia Ortiz 0 Reputation points
2024-06-24T19:30:43.4933333+00:00

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.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,227 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Yitzhak Khabinsky 25,726 Reputation points
    2024-06-24T19:48:07.42+00:00

    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.


  2. ZoeHui-MSFT 34,916 Reputation points
    2024-06-25T05:46:53.1166667+00:00

    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.

    0 comments No comments