Help with format and csv
 

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

Help with format and csv
 

It would be worth looking at your CSV file in notepad to see if the
calculation is off at that stage. It sounds like you have some rounding
errors here - I suspect that some of the charges are based upon
percentage calculations?


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=571223