Hi,

I have to import data from a Excel sheet into a table. The Excel format is
"Generic' and the values can be numeric or alphanumeric. I get a mixed result
for values like i.e. for 1.1, 1.2 ,21.1, 21.1 (these are only exsamples) I
get 1.100000000001, 1.2, 21.1000000000, 21.1999999999 etc. My destination
column has to be char or varchar, size is set to 10. Why is SQL server
reformatting the number format and even changing the value (i.e. from 21.2 to
21.199999999999)? is there a way to fix this? The problem is, that the value
is a ID code which could contain characters in the future.

Any ideas? Thank you

Cheers

Peter