When importing from Excel using SSIS, depending on the version of Office installed (32/64 bit), we can sometimes get the error

The 'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine

Googling for the error, indicates that the version of the Microsoft Access Database Engine 2016 Redistributable is not the right one for the system - 64 bit required instead of 32bit. Unfortunately, the simple act of uninstalling the 32bit engine and installing the 64bit doesn't always cure the problem. According to the web page and the GUI installer, the 32bit and 64bits cannot co-exist and one must be uninstalled before installing the other.

However, there is a workaround and that the two versions will co-exist using this trick: Keep whichever version is installed and then install the version from an elevated command prompt using the /Quiet flag. This stops the installer from checking for the presence of the other version.

accessdatabaseengine /Quiet

or

accessdatabaseengine_64 /Quiet

Then SSIS packages will happily run as they are intended.