"The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine" Error in importing process of xlsx to a sql server
Sql Server-2008ExcelOledbSql Server-2008 Problem Overview
I have a 64 bit windows 7 and SQLServer 2008 R2 (64 bit)
I follow the instructions that are here to import excel file to sql server but in figure3 section of that post when I try to access excel file and when I click next this error make me stop:
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
I search the web i knew that I must install AccessDatabaseEngine_x64
.
but when I install it I have a same problem
Can you please help me what to do?
Sql Server-2008 Solutions
Solution 1 - Sql Server-2008
Install the following to resolve your error.
2007 Office System Driver: Data Connectivity Components
AccessDatabaseEngine.exe (25.3 MB)
> This download will install a set of components that facilitate the > transfer of data between existing Microsoft Office files such as > Microsoft Office Access 2007 (*.mdb and .accdb) files and Microsoft > Office Excel 2007 (.xls, *.xlsx, and *.xlsb) files to other data > sources such as Microsoft SQL Server.
Solution 2 - Sql Server-2008
Excel 2010 driver is 64 bit, while the default SSMS import export wizard is 32 therefore the error message.
You can import using the Import Export Data (64 bit) tool. ("C:\Program Files\Microsoft SQL Server\110\DTS\Binn\DTSWizard.exe") notice the path is not Program Files x86.
Solution 3 - Sql Server-2008
Save it as a CSV file and import it as a flat source file.
Solution 4 - Sql Server-2008
This is the only install that resolved the issue for me.
SQL 2008 r2 w/ office 2010 64bit: "2007 Office System Driver: Data Connectivity Components"
Solution 5 - Sql Server-2008
Currently, Microsoft don't provide download option for '2007 Office System Driver: Data Connectivity Components' and click on first answer for '2007 Office System Driver: Data Connectivity Components' redirect to Cnet where getting download link creates confusion.
That's why who use SQL Server 2014 and latest version of SQL Server in Windows 10 click on below link for download this component which resolve your problem : - Microsoft Access Database Engine 2010
Happy Coding!
Solution 6 - Sql Server-2008
I had the same problem. SSMS launches the 32bit version of the import and export wizard which has this issue. Try launching the 64bit version application and it should work fine.
Solution 7 - Sql Server-2008
I had no luck until I installed the 2010 version link here: https://www.microsoft.com/en-us/download/details.aspx?id=13255
I tried installing the 32 bit version, it still errored, so I uninstalled it and installed the 64 bit version and it started working.