How to Fix Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine

Steve Clark 21 Reputation points
2024-04-12T15:06:30.7966667+00:00

I am doing a Import Data from an Excel spreadsheet to a table. I get the following message : Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine. What will resolve this error?

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,760 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Greg Low 1,495 Reputation points Microsoft Regional Director
    2024-04-14T12:36:27.6333333+00:00

    Try installing this driver to get the provider: https://www.microsoft.com/en-us/download/details.aspx?id=54920

    0 comments
  2. LucyChen-MSFT 1,045 Reputation points Microsoft Vendor
    2024-04-15T02:31:21.9133333+00:00

    Hi @Steve Clark,

    Thanks for your information.

    From the error message, I find the article which describe the solution to this issue in detail. Hope this can help you well.

    User's image

    Best regards,

    Lucy Chen

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    https://docs.microsoft.com/en-us/answers/support/email-notifications