The 'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine. (System.Data)

Question

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)

Answer 1

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

Answer 2

I had success doing the following (I use Excel 2016 and SSMS 2017) From Excel File -> Export -> Change File Type -> Excel 97- 2003 (*.xls)