Forum Discussion

Karlena Bucknor's avatar
Karlena Bucknor
Copper Contributor
Dec 08, 2018

Installed MySQL connector/NET 8.0.13 but still doesnt connect in Excel 2016

I'm trying to connect to MySQL database using Data > New Query > From Database > From MySQL Database

 

However i am getting the error "This connector requires one or more additional components to be installed before it can be used"

 

I have already installed the MYSQL Connector/NET 8.0.13

 

But i continue to get the error box in Excel

 

I am using Excel 2016, 64 bit, with Professional Plus 2016

 

Any help would be appreciated 

thanks very much

Connector
excel
MySQL
Power BI
PowerQuery
  • nmhillusion's avatar
    nmhillusion
    Copper Contributor
    Dec 26, 2021

    Karlena Bucknor 

    I have the same problem and I resolved it by install an additional connector for dotNet: ADO.NET Driver for MySQL (Connector/NET). So I have installed 2 connectors to connect to MySQL DB for ODBC and ADO.

     

     

    • slavick10's avatar
      slavick10
      Copper Contributor
      Jan 02, 2022
      That fixed it for the same issue in Excel 2019. Thanks so much.

Resources