The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine

 

ERROR:

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

EXPLANATION:

I received an error message when I wanted to import a Microsoft Excel file with the extension * .xlsx to SQL Server 2014.

Excel 2007 was already in the Excel Version list, but obviously something was missing.

SOLUTION:

So I found the solution in a forum, but I wanted to record it here, especially in order to be more compact. If you download and install the following file on SQL Server Server, your problem is resolved without ever restarting the server or SQL Server Management Studio.

2007 Office System Driver: Data Connectivity Components

Depending on the version of excel or the operating system that you use, the Acces Database Engine may change. You should download the appropriate link from the site.

You can download and install Microsoft Access Database Engine 2010 from the link below.

Microsoft Access Database Engine 2010 Redistributable

Ekrem Önsoy
Author: Ekrem Önsoy

The original article was written in Turkish by Ekrem Önsoy and translated to English by dbtut with the consent of the author. The copyright of the article belongs to the author. The author shall not be liable in any way for any defect caused by translation.

Leave a Reply

Your email address will not be published. Required fields are marked *