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
Software to connect apache derby DB with Excel
I would like to use a Apache derby Database as source for an excel file so that I can use the tables and manipulate them in Excel. I have tried to connect the derby DB with the Derby ODBC Driver from easysoft but I dont get a license. It always says that a license is already in use for my machine, but I can cant select a product in the Easysoft Data Access License Manager. Does anyone have a solution for the easysoft issue? Or does anyone know an alternative solution/software? Thanks alot!