Trying to import Excel file into SSMS 20.2 and I get this error

Brooke 0 Reputation points
2025-01-18T05:02:38.6833333+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


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

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 40,356 Reputation points
    2025-01-20T02:40:11.6+00:00

    Hi Brooke

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

    Try to install the Access database engine.

    Check the download link and the blog to install both 32bit and 64bit driver.

    Access 2016 runtime

    Installing the Microsoft.ACE.OLEDB.12.0 Provider for Both 64-bit and 32-bit Processing

    Regards,

    Zoe Hui


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

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.