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