Having a problem with the precision on some values when DTS exports from Excel.
e.g. 0.08 appears as 8.0 in the text file. Does not occur for all values
only when the whole or tenths position is 0. 1.0 and 0.5 translate ok but
anything like 0.05 or 0.054 show up as 5.0 or 5.40. Column in Excel is
defined as numeric with 4 decimal places. I'm using SQL 2000 Enterprice
edition. Don't have the latest service packs either.