SQL 2012 - Import Data Wizard - Excel - The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. (System.Data)

Question

I have a windows 7 x64 computer with SQL 2012 Developer installed.  In addition I have Office 2010 Professional(x64) ,  and Visual Studio 2010 Ultimate (x64) installed as well.   the SQL Service account is a local Administrative account on the computer and a sysadmin within SQL as is my account as well.   this is a development installation.

I am trying to import an Excel workbook into a database table using the Import Export Wizard.  However, when I complete the data source page I receive the following error.   "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. (System.Data)"   in response, i have installed the X64 version of the Microsoft Access Database engine  AccessDatabaseEngine_x64  which seems redundant to the current 2010 Access database installation, but regardless, this did not resolve the issue. 

At one point I had..  uninstalled office,  installed the x64 access engine and tested, restarted tested again, reinstalled office 2010, tested again, etc... without success.

any assist would be appreciated.

SDavis

Answer 1

Scott,

The problem you are likely having is the Import/Export Wizard is being launched as the 32-bit version.  This is probably due to you right clicking on a database and clicking on import and since SSMS is a 32-bit program it will launch 32-bit processes.  Try explicitly running the Import/Export Wizard (64-bit) by clicking on Start->Program Files->Microsoft SQL Server 2012->Import and Export Data (64-bit) to import your data from a 64-bit datasource.

I hope this helps.

Noral

Answer 2

That was the problem. thanks Noral..  

There should be some logic in the SSMS to determine this based on when you open up the Client.

however, ill take what i can get and this is resolved.

thanks again .

SD

---

Scott Davis

Answer 3

Hi Noral

Thanks for this worked for me too!!!

Answer 4

32 bits only works as follows:

SELECT 
CODIGO,
NOMBRE,
NIF 
FROM 
OPENROWSET
(
'Microsoft.Jet.OLEDB.4.0', 
'Excel 8.0;Database=E:\web\Files\Archivo.xls', 
Hoja1$
)