Getting error when trying to import an excel file to mssql server 2022 (ssms-19)

Dhanesh Kumar 40 Reputation points

TITLE: SQL Server Import and Export Wizard

The operation could not be completed.


The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. (System.Data)



Screenshot 2023-10-13 101320

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

Accepted answer
  1. Olaf Helper 41,101 Reputation points

    The 'Microsoft.ACE.OLEDB.12.0' provider is not registered

    As the message says, if you want to use ACE data provider, you have to install it first and this in the same 32/64 bitness as the wizard you are using.

    => Microsoft Access Database Engine 2010 Redistributable

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. PercyTang-MSFT 12,426 Reputation points Microsoft Vendor

    Hi @Dhanesh Kumar

    You can refer to the previous thread. Hope it can help you.

    Best regards,

    Percy Tang

    0 comments No comments