onvert Number from SQL Server to Acess

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jose - 12 Apr 2008 10:56 GMT

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

Reply to this Message

Tom van Stiphout - 12 Apr 2008 18:29 GMT

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 have a problem.
>I exporta data from Sql Serv to Ms Access and the precision of the numbers
[quoted text clipped - 11 lines]
>Thanks
>JCP

Reply to this Message

a a r o n . k e m p f @ g m a i l . c o m - 20 Apr 2008 21:32 GMT

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

> On Sat, 12 Apr 2008 02:56:00 -0700, Jose
>
[quoted text clipped - 26 lines]
>
> - Show quoted text -

Reply to this Message