SQL Error – The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the loc...
source link: https://sqlwithmanoj.com/2016/12/24/sql-error-the-microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine-system-data/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
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.
Related
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK