Upon following the instructions here, which links here, and installing the latest version (8.0.30) ODBC connector, I still receive the following unhelpful error message when selecting Data -> Get Data -> From Database -> From MySQL Database:
This connector requires one or more additional components to be installed before it can be used.
I have restarted Excel and the machine multiple times. I have tried installing the 32-bit and 64-bit connectors. I have tried installing from the standalone MSI and the MySQL Installer application. I have even tried installing the ADO.NET connector as well, as quizzically suggested here. I have tried looking in the Event Viewer for application errors. Any suggestions are appreciated, as I'm out of ideas.
Running Microsoft® Excel® for Microsoft 365 MSO (Version 2206 Build 16.0.15330.20260) 64-bit under Windows 11.
UPDATE: More people with the same problem over on Microsoft forums.
Best Answer
I headed over the MySQL bug tracker and found this one: MySQL Bugs: #107316: MySQL 8.0.29 introduces a bug which prevents use of the Connector software
Based on that, and the hidden documentation to additionally install the ADO.NET connector, I've finally got this working with 64-bit Excel 365 by installing the 64-bit ODBC Connector, version 8.0.28, and the 32-bit ADO.NET connector, version 8.0.28.
Note that there is only a 32-bit ADO.NET connector available.