Share via

ACE.OLEDB.12.0 provider is not registered on the local machine

Admin Team TGS 0 Reputation points
2026-03-04T07:35:23.9466667+00:00

Hello,

We have a client that tried to import an excel using the import and export wizard and he recceived the following error:  

 

The operation could not be completed.

Additional information:

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

 

 

I don't have that much experience with SQL and the process that the client tried to do, but these are the checks I did based on what info I found so far:

  • checked if SQL Server instance, the Import and Export Wizard, and the Access Database components are all running on the 64-bit version
  • updated/reinstalled Access Database
  • installed Microsoft Access Runtime  I was unable to find additional info about this issue.

Other info about the enviorment:

  • server is a VM that runs both on Azure (production) and VMWare (testing), OS: Windows Server 2012 - SQL Instance is SQL EXPRESS v.14.0.2095.1

 

What other info would be useful to provide?

Thank you

SQL Server Database Engine

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 133.1K Reputation points MVP Volunteer Moderator
    2026-03-04T12:11:02.08+00:00

    The important thing here is the version of SSMS. Older versions of SSMS were 32-bit. Recent versions are 64-bit. so make sure that your runs SSMS 22, and if not, your client should download and install it.

    0 comments
  2. Nithin Krishna Madadi 0 Reputation points Microsoft External Staff Moderator
    2026-03-04T09:40:27.9466667+00:00

    Hi Admin Team TGS
    Thanks for reaching out to the Microsoft Q & A Forum.

    You can run the SQL Server Import and Export Wizard directly through SQL Server Management Studio (SSMS).

    To run the wizard outside of SSMS, you need to have DTSWizard.exe, which you get when you install one of the following:

    If you want to run the wizard, but you don't have Microsoft SQL Server installed on your computer, you can install the SQL Server Import and Export Wizard by installing SQL Server Data Tools (SSDT). For more info, see Download SQL Server Data Tools (SSDT).

    I hope this information helps. Please do let us know if you have any further queries.
    Thank you

    0 comments

Your answer

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