SQL Import Wizard Error Importing Excel Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

Home/Recent Posts, Uncategorized/SQL Import Wizard Error Importing Excel Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

SQL Import Wizard Error Importing Excel Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

 

Symptoms

Using SQL Server 2014 import tool from within the Management Studio to import an Excel spreadsheet this error message appears:

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

error message

The spreadsheet opens fine on the machine using Excel

Solution

Microsoft Office 64bit Version is installed, but the management studio is 32bit and opens the 32bit Import Wizard

Go to Start, Programs, SQL Server 2014 and run the 64bit Import and Export Wizard

import wizard 64bit

 

By | 2015-08-05T15:35:19+00:00 August 5th, 2015|Recent Posts, Uncategorized|0 Comments

About the Author:

Leave A Comment