Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-297717%22%20slang%3D%22en-US%22%3EInstalled%20MySQL%20connector%2FNET%208.0.13%20but%20still%20doesnt%20connect%20in%20Excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-297717%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20connect%20to%20MySQL%20database%20using%20Data%20%26gt%3B%20New%20Query%20%26gt%3B%20From%20Database%20%26gt%3B%20From%20MySQL%20Database%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%20i%20am%20getting%20the%20error%20%22This%20connector%20requires%20one%20or%20more%20additional%20components%20to%20be%20installed%20before%20it%20can%20be%20used%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20already%20installed%20the%20MYSQL%20Connector%2FNET%208.0.13%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20i%20continue%20to%20get%20the%20error%20box%20in%20Excel%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20using%20Excel%202016%2C%2064%20bit%2C%20with%20Professional%20Plus%202016%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20appreciated%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%20very%20much%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-297717%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EConnector%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMySQL%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Epowerquery%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Karlena Bucknor
Visitor

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