1

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.

Improve this question
6
  • Have you downloaded the 64-bit connector?
    – harrymc
    Commented Aug 4, 2022 at 14:16
  • @harrymc Yes, I have tried both 32-bit and 64-bit connectors.
    – jordanpg
    Commented Aug 4, 2022 at 15:48
  • As a workaround, can you create an ODBC Data Source using the driver (search ODBC in start menu)? Then in Excel: Data > Get Data > From Other Sources > From ODBC
    – Cpt.Whale
    Commented Aug 4, 2022 at 16:39
  • @Cpt.Whale thanks, I had noticed that still worked. It's very kludgy and in particular, less well-suited for the inexperienced users I'm working with.
    – jordanpg
    Commented Aug 4, 2022 at 16:51
  • Is it a Windows 11 compatibility issue?
    – Lee
    Commented Aug 5, 2022 at 9:41

2 Answers 2

Reset to default
1

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.

Improve this answer
1

I found that the Microsoft documentation links to the generic MySql ODBC Connectors page, which at the time of writing is listing the connectors at version 8.0.30.

However, I found that only the older GA versions of the connectors work with my version of Excel

Microsoft® Excel® 2019 MSO (Version 2207 Build 16.0.15427.20166) 32-bit

The versions that worked for me are 5.3.14. In my case I installed both, but since my Excel is 32Bit I guess only the 32-Bit/x86 connector was required. In your case I'd install the 64-Bit/x64 connectors. To play it safe installing both should be fine.

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .