I am WELL past the point of frustration. This used to be an easy error to fix. Now, it's not. So, please tell me how.
“The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine” Error in importing process of xlsx to a sql server
Well, we'll need a bit more detail as to what the situation is. i.e. what's installed and what's not.
In general, you will probably have to install either the 2007 ACE Engine redistributable or the 2010 one depending on whether you are working in 32 or 64 bit.
The ACE components are no longer available unless you install them.