Installed "MySQL connector/Net 6.10.4" but don't see Excel 2016 menu selection "from MySQL Database"

Hi everybody, i'm new with Excel 2016 database connection while i came from Excel 2010.. I would to use MySql database connection like it describes here: https://support.office.com/it-it/articl...

BI & Data Analytics

training

Andy Frei
Dec 04, 2017
Power Query Premium: All Power Query features available for: Professional Plus, Office 365 ProPlus or Excel Standalone
Power Query Public: Available for all other Office Desktop SKUs. Includes all Power Query features, except the following ones: Corporate Power BI Data Catalog, Azure-based data sources, Active Directory, HDFS, SharePoint Lists, Oracle, DB2, MySQL, PostgreSQL, Sybase, Teradata, Exchange, Dynamics CRM, SAP BusinessObjects, Salesforce

amir.sadighian

Copper Contributor

Jan 08, 2018

Sorry. I have the same issue and I read the responses. But couldn't quite understand the solution. Could you please explain how I can solve this issue?

Andy Frei

Copper Contributor

Jan 09, 2018

What Office version do you have?

It only works if you have Professional Plus, Office 365 ProPlus or Excel Standalone.

b3333n
Copper Contributor
Apr 27, 2020
Hi Andy Frei

I'm currently facing the same problem - but I just activated my Office 365 Pro Plus licence, ran an update and the MySQL etc. options still don't appear.
What am I doing wrong?

Thanks in advance for your help!
amir.sadighian
Copper Contributor
Jan 09, 2018
Thank you very much Andy. I dont have those. So alternatively downloaded an ODBC Installer and connected to MySQL through that.

Forum Discussion

Installed "MySQL connector/Net 6.10.4" but don't see Excel 2016 menu selection "from MySQL Database"

Resources