onvert Number from SQL Server to Acess

  • Thread starter Thread starter Jose
  • Start date Start date
J

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
 
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.
 
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
 
Back
Top