Error message saying Microsoft.Ace.oledb.12.0 provider is not registered on the local system when using SSMS import wizard from Excel

Greg Booth 1,346 Reputation points
2023-02-08T17:56:51.2066667+00:00

Customer is trying to use SSMS 18.0 to import data from Excel.

They get an error message "Microsoft.Ace.oledb.12.0 provider is not registered on the local system"

How do we fix this ?

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,466 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,643 questions
0 comments No comments
{count} votes

Accepted answer
  1. ZoeHui-MSFT 40,511 Reputation points
    2023-02-09T01:37:36.1+00:00

    Hi @Greg Booth

    Please try to install the Microsoft.ACE.OLEDB.12.0.

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

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

    Regards,

    Zoe Hui


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

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Zahid Butt 956 Reputation points
    2023-02-08T18:32:05.71+00:00
    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.