I'm getting crazy with this error:
There's a similar thread which I went trough but could not find solution for my case: 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine
I'm working with power query within Excel and connecting to a local Access database.
After above message I installed Microsoft.ACE.OLEDB.12.0' 32-bit (AccessDatabaseEngine.exe) but then, when refreshing the query in Excel I get this further and worst error:
This is my excel version:
Edit: As suggested I installed Access Engine for 2016, but I get now this further error: