MySQL Forums
Forum List  »  MySQL for Excel

Value 'Preferred' is not of the correct type
Posted by: Michael Stembridge
Date: May 01, 2018 09:36AM

Hi all,

I am trying to create a link from an Excel spreadsheet to a MySQL database.I am using Windows 10, running Office 365 (Excel 2016). I have installed the latest MySQL connectors (8.0.11) and MySQL Workbench.

I can access the database no problem using "MySQL Workbench 6.3 CE" and also import data from the database using the "MySQL for Excel" add-in.

However when I try to make a connection in Excel using the built in "Get Data->From Database->From MySQL Database", then enter the server name and database name, I get the following error in a pop up box:

Unable to connect
We encountered an error while trying to connect
Details: "Value 'Preferred' is not of the correct type."

I have tried un-installing and re-installing the connectors, tried installing the previous version of connectors.

Any clues how I can make the connection to the database via the "Get Data" menu?



Options: ReplyQuote

Written By
Value 'Preferred' is not of the correct type
May 01, 2018 09:36AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.