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

Dhanesh Kumar 40 Reputation points
2023-10-13T04:52:54.18+00:00

TITLE: SQL Server Import and Export Wizard


The operation could not be completed.


ADDITIONAL INFORMATION:

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


BUTTONS:

OK

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
    2023-10-13T05:02:54.54+00:00

    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
    2023-10-13T05:49:12.69+00:00

    Hi @Dhanesh Kumar

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

    https://learn.microsoft.com/en-us/answers/questions/634023/sql-server-excel-import-the-microsoft-ace-oledb-12

    Best regards,

    Percy Tang

    0 comments No comments