appending excel data with large decimals
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
Subject
Views
Written By
Posted
appending excel data with large decimals
1445
September 27, 2016 12:06AM
798
September 28, 2016 03:08PM
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.