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

4
votes

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:

iODCB Data Source Administrator

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

IM003 iODBC Driver Manager Specified driver could not be loaded

Same problem with both, Unicode and ANSI drivers.

2
mysqlexcelmacosiodbc
Does it support the version of excel that you have? Are both appropriately up-to-date? – Solar Mike
I installed iODBC and the MySQL ODBC driver today, iODBC is verion 3.52.12 and the Connector/ODBC is version 8.0.12, all up-to-date according to Apple Open Source and MySQL sites. – M Garcia

2 Answers

6
votes

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.
0
votes

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.