Help with format and csv

  • Thread starter Thread starter Jane Doe
  • Start date Start date
J

Jane Doe

Hello

I have an excel spreadsheet with several columns referring to charges and
the last column refers to "Total Charges".
The columns have been formatted to number with two decimal. Every month the
figure changes and whenever I import the excel to MS Access, the grand total
is off with a few cents.

I tried converting the excel to csv and import to MS Access, with same
result.

Is there something I was doing wrong here or is this an MS Access issue?

Pls advise.
TIA!
Bob
(e-mail address removed)
 
It would be worth looking at your CSV file in notepad to see if th
calculation is off at that stage. It sounds like you have some roundin
errors here - I suspect that some of the charges are based upo
percentage calculations
 
Back
Top