macOS Connector/MySQL ODBC driver could not be loaded in Excel for Mac 2016

Question

I am working with Excel for Mac Version 16.18 on High Sierra 10.13.6. Installed Connector/ODBC 8.0.12 for macOS, tested the connection to my database with iODBC Data Source Administration (64-Bit) and worked:

When I try connecting with Excel with the save driver and credentials I get the following error:

Same problem with both, Unicode and ANSI drivers.

Answer 1

I was able to connect to MySQL with Microsoft Excel Version 16.19 by making the following adjustments:

1. I copied the driver's whole directory /mysql-connector-odbc-8.0.12-macos10.13-x86-64bit to /Library/ODBC (why? see https://bugs.mysql.com/bug.php?id=89931, and Is there a way to get ADODB to work with Excel for Mac 2011?) ; basically the reason for that is the driver gets downloaded to /usr/local and Excel, being sandboxed, cannot access that location.
2. Updated the file odbc.ini, also located in /Library/ODBC, with the driver's new location.

Answer 2

I had the same problem and I solved it:

Go to the "ODBC Drivers Tab," select de driver and "Configure the driver," then add the odbcinst.ini path in the "Setup file name":

Answer 3

I encountered this as well and I fixed it by changing ALL odbc.ini files to whatever you want change to. I think somehow excel use other odbc.ini files that are not in/Library/ODBC directory.