I have Windows 10 pro x64,
Excel 2016 32 bit
and Sql server 2017.
I want to import excel file to sql server, I need to use 32-bit wizard because Microsoft Excel is not shown in 64-bit version, but I face this error:
The 'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine. (System.Data)
Sql-server – The ‘Microsoft.ACE.OLEDB.16.0’ provider is not registered on the local machine. (System.Data)
excelms-accesssql server
Related Topic
- Sql – import from excel to sql server: The ‘Microsoft.ACE.OLEDB.12.0’ provider error
- Sql-server – ‘Microsoft.ACE.OLEDB.16.0’ provider is not registered on the local machine. (System.Data)
- Ms-access – The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine even if it actually IS installed
Best Answer
If you are having problems installing the engine because components are already installed, do this (from Microsoft):
If Office 365 is already installed, side by side detection will prevent the installation from proceeding. Instead perform a /quiet install of these components from command line. To do so, download the AccessDatabaeEngine_x64.exe to your PC, open an administrative command prompt, and provide the installation path and switch Ex: C:\Files\AccessDatabaseEngine_x64.exe /quiet