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

Question

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

Admin Team TGS 0

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

Nithin Krishna Madadi 0 Reputation points Microsoft External Staff Moderator

2026-03-09T11:44:38.94+00:00

Hi Admin Team TGS,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you.
Nithin Krishna Madadi 0 Reputation points Microsoft External Staff Moderator

2026-03-12T07:25:46.3966667+00:00

Hi Admin Team TGS,

May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.

Thank you

Answer recommended by moderator

Nithin Krishna Madadi 0 Microsoft External Staff Moderator

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:

SQL Server.
SQL Server Data Tools (SSDT) for Visual Studio 2019 and later with the SQL Server Integration Services extension.
SQL Server Data Tools (SSDT) for Visual Studio 2017 with the SQL Server Integration Services option selected in the installation wizard.

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

1 additional answer

Your answer

Nithin Krishna Madadi 0 Reputation points Microsoft External Staff Moderator

2026-03-09T11:44:38.94+00:00

Hi Admin Team TGS,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you.
Nithin Krishna Madadi 0 Reputation points Microsoft External Staff Moderator

2026-03-12T07:25:46.3966667+00:00

Hi Admin Team TGS,

May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.

Thank you

Answer 1

Erland Sommarskog 136.2K MVP Volunteer Moderator

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