MySQL Forums
Forum List  »  MySQL for Excel

appending excel data with large decimals
Posted by: Andrew Juszczak
Date: September 27, 2016 12:06AM

On attempting to append data formatted as number with decimals to MySql table which has the corresponding field defined as double, mysql for excel indicates incoming fields are VarChar and cannot map to the table's double type. One field has 14 positions to the right of the decimal point and the other field has 15 positions to the left of the decimal point. MySql for Excel is 1.3.6 running as a plugin in Excel 2007. Plugin connects to MySql 5.6.16 running under XAMPP 1.8.3

Options: ReplyQuote


Subject
Views
Written By
Posted
appending excel data with large decimals
589
September 27, 2016 12:06AM


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.