onvert Number from SQL Server to Acess

[Jose]

I have a problem.
I exporta data from Sql Serv to Ms Access and the precision of the numbers
is not the same.
for example
SQL Server (real) Access (Double)
2.6 2.5999999046
0.8 0.8000000119

I chenged the datatype in sql server real to float and the mistake sitll
continue.

Any suggetions how can export data from Sql Server and fix these problems?

Thanks
JCP

 

[Tom van Stiphout]

On Sat, 12 Apr 2008 02:56:00 -0700, Jose

That's not a mistake, just the impossibility of a binary system to
accurately describe a floating point value.

If it makes you feel better, you can run an update statement and apply
roundoff. Personally I would just make sure the PRESENTATION of the
data is rounded off to one decimal.

-Tom.

 

[a a r o n . k e m p f]

I think that it is best to store decimals with only 2 digits to the
right.

that's the best-- from a performance / storage perspective.. that is.

I generally avoid floats like the plague.

-Aaron