Share via

SSMS Import data for Excel needs 'Microsoft.ACE.OLEDB.12.0' registered

King, Arthur 101 Reputation points
2024-12-03T20:55:45.6766667+00:00

I realize this is a common question, but I've tried several of the existing solutions and none of them have helped.

My new work PC is Windows 11 23H2, and I'm using SQL Server Management Studio v 20.2.30.0. I'm trying to import an Excel workbook using "Tasks -> Import Data", something I've done on my old PC many, many times. However, I now keep getting the error: "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine."

Any assistance would be greatly appreciated. Thanks!

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

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. King, Arthur 101 Reputation points
    2024-12-03T21:49:03.7066667+00:00

    Hi all! Something odd is going on with this web site, so I can't read replies, but just in case this goes through...

    This video solved my problem: https://www.youtube.com/watch?v=byYkPzdESeI

    Apparently you have to install the 32 bit version from the command prompt using the /QUIET switch.

    Seems ludicrously convoluted, but there it is, and solved my issue. Hope this helps someone else!

    1 person found this answer helpful.
    0 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.