SQL Error – The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine. (System.Data)
I was trying to export a SQL table to Excel and I got below error:
TITLE: SQL Server Import and Export Wizard
——————————
The operation could not be completed.
——————————
The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine. (System.Data)
——————————
After searching a bit I came to know that the above provider is not installed, and I need to install the Microsoft Access Database Engine setup, to facilitate the transfer of data between existing Microsoft Office files such as “Microsoft Office Access 2010” (*.mdb and *.accdb) files and “Microsoft Office Excel 2010” (*.xls, *.xlsx, and *.xlsb) files to other data sources such as “Microsoft SQL Server”.
–> Get the Microsoft Access Database Engine 2010 Redistributable, [link].
There will be two files:
1. AccessDatabaseEngine (for. 32-bit)
2. AccessDatabaseEngine_x64 i.e. 64-bit
If your SQL Server is 32 bit, then install just the first one.
But if its 64 bit, then install both, first 32 bit & then 64 bit.
Thanks for the post,recently i faced same issue when i was importing data from excel into sql server.
Thank you!! VERY helpful, and easy to understand. I esp. appreciate the explanation that both 32 & 64 bit is necessary, and which order to install them.
Really loved it, I was searching for the solution on the internet and found your page, It really helped me fix the issue within few minutes. Keep up the good work mate
muuuuuuuuuuuchas gracias joven, feliz navidaaaaaaaaaaaaaaaaad
GREAT MAN….superb…