Numeric Precision Is Lost When Import Data From Excel
Posted 01 March 2012 - 06:57 PM
i use Powertools -> Import External Data with datasource Excel 97-2003 format .xls file. i map one of the columns to DOUBLE(24,8) and the destination table exists with that column also DOUBLE(24,8). but after the import, the data has only 6 digits of precision (the last 2 decimal places are always 00).
am i doing something wrong?
Posted 01 March 2012 - 07:04 PM
Posted 02 March 2012 - 09:14 AM
I don't know if Microsoft has backported this to Office 2007 (we are checking). Do you have all Office 2007 Servicepacks installed?
Posted 02 March 2012 - 03:17 PM
i am in a corporate environment and the IT department controls all software so i'm not sure if i can get anything newer installed.
in any case, it looks like it's nothing that SQLyog can fix. thanks for checking!
Posted 12 March 2012 - 11:39 AM
This is reproducible for us if the double datatype column is not the first column in the Excel sheet. This seems to be a driver issue and nothing to do with SQLyog. Office 2007 SP3 also it is reproducible :-(
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users