SQL Import/export wizard using excel and this error: The ‘Microsoft.ACE.OLEDB.16.0’ provider is not registered on the local machine. (System.Data)

Question

Trying to use  SQL server import/export tool and data source excel and get this error:

The ‘Microsoft.ACE.OLEDB.16.0’ provider is not registered on the local machine. (System.Data)

I have SSMS 18, (it was working the same in sql 17.9, was thinking upgrading may help), Windows 10, 64 bit office 365.

I have installed Access Database Engine x64.exe (multiple times).

I try to change the excel version in the wizard and I get the same message but it references”…OLEDB.12.0″, “…OLEDB.15.0” and this is for Excel 2016

At a loss and hoping for assistance.

I  have tried multiple things by researching what others are doing but to no avail. I need this functionality to work.

Currently, I’m relying on one person who is not getting this error (he has 32 bit office and I have 64 bit) but he is going on vacation and I need to be able to do the tasks using import/export wizard. I don't think the answer is rolling back to 32 bit for this one task to work.

Answer 1

Hi,

Thank you for writing to Microsoft Community Forums.

We understand how difficult it is, when the device doesn't work in the way it should. As you are getting an error while using SQL server import/export tool.

However, we would suggest you to post this query in MSDN forums, where we have participating developers and support professionals who are well equipped with the knowledge on this query to assist you with appropriate details. 

Aditya Roy

Microsoft Community – Moderator

Answer 2

I couldn't find SQL Server it when I posted that originally, thought something was off. Thank you