MySQL Forums
Forum List  »  MySQL for Excel

MySQL for Excel data types not documented
Posted by: Olli Mannisto
Date: October 29, 2018 06:34AM

I installed MySQL for Excel and imported my table. Or rather tried to. I promptly got the "Input string was not in a correct format." error message.

After a bit of digging, someone "fixed" the issue by converting everything to Varchar data types. So some of the MySQL data types are not supported, fair enough.

But is there anywhere a table that shows what *is* supported? Is this mentioned in the documentation at all?

From a bit of experimentation at least int and decimal fail. Varchar and multilinestring work ok.

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL for Excel data types not documented
609
October 29, 2018 06:34AM


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.