1

Windows 10 has Excel 2019, and is trying to import by right clicking DB, import data, excel version only provides Excel 2016 .xlsm and gives this error “Microsoft.ACE.OLEDB.16.0” provider is not registered on the local machine. We have upgraded the SQL server from 2016 to 2019. I have tried several troubleshooting techniques yet no success, any guidance on some solutions? Any help would be greatly appreciated.

5 Spice ups
2

Can’t use the Access ODBC driver or OLEDB provider outside Office Click-to-Run applications

Click-to-Run installations of Office run in an isolated virtual environment on the local operating system. Some applications outside Office may not be aware of where to look for the installation in the isolated environment.

The answer appears to be that you need to install the Access Database Engine on the SQL Server - or - change your process to work without the Excel 2019 import (i.e. import a different way). See below:

ODBC or Microsoft.ACE.OLEDB.12.0 OLEDB provider connections that will be used outside of Office

1 Spice up
3

Re-read your post - are you using SSMS on the Windows 10 computer (which has Excel) to import local data (spreadsheet) to a remote connected SQL Server? If that is the situation, then the Acess Database Engine will need to be installed on the Windows 10 machine.

4

The Microsoft Access Database Engine 2016 Redistributable is installed on both the server and the Windows 10 workstations. We used the 32 bit version, b/c that is what bit Office 2019 is.

5

I uninstalled the Redistributable and installed it this way (32 bit version) via command line -

C:\Users<User_Name>\Downloads\AccessDatabaseEngine.exe /quiet

Now it appears to work for me, checking with the user now to see if she can do the same…waiting on her response.