Rounding difference in Access 2003 text exports

  • Thread starter Thread starter Dana M
  • Start date Start date
D

Dana M

We're finding rounding differences when exporting Access 2003 data to text
files - about $4000 difference from the original Excel Worksheet. # lines -
about 250,000
Original Dollars - $800,000,000 +. Access export is under by about $4000.
Floating decimal in original Excel data, which is imported to Access and
seems not to lose any data, more divisions and calculations are done driving
the dollars out to a large customer base. Before exporting, data is summed
and foots to the original $800MM+. Data is exported using Export Wizard as
comma delimited. I wonder - are there Advanced Options in the Export Wizard
we should be using in order to get closer to the original numbers?
 
We're finding rounding differences when exporting Access 2003 data to text
files - about $4000 difference from the original Excel Worksheet. # lines -
about 250,000
Original Dollars - $800,000,000 +. Access export is under by about $4000.
Floating decimal in original Excel data, which is imported to Access and
seems not to lose any data, more divisions and calculations are done driving
the dollars out to a large customer base. Before exporting, data is summed
and foots to the original $800MM+. Data is exported using Export Wizard as
comma delimited. I wonder - are there Advanced Options in the Export Wizard
we should be using in order to get closer to the original numbers?
Click to expand...

If the field in Access is a Single Float, then it will be limited to about
seven digits of precision: e.g. 800,000,000 cannot be distinguished from
799,999,900 or from 800,000,099.

If you use a Currency datatype instead of any sort of Number, you'll get a
range into the trillions and NO roundoff error.
 
Dana M said:
We're finding rounding differences when exporting Access 2003 data to text
files - about $4000 difference from the original Excel Worksheet. #
lines -
about 250,000
Original Dollars - $800,000,000 +. Access export is under by about $4000.
Floating decimal in original Excel data, which is imported to Access and
seems not to lose any data, more divisions and calculations are done
driving
the dollars out to a large customer base. Before exporting, data is
summed
and foots to the original $800MM+. Data is exported using Export Wizard
as
comma delimited. I wonder - are there Advanced Options in the Export
Wizard
we should be using in order to get closer to the original numbers?
Click to expand...
 
Back
Top