Dec 07 2018 05:16 PM
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
Dec 05 2019 12:39 AM
Dec 25 2021 07:42 PM
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.
Jan 02 2022 01:03 AM