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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

.csv Re-Format Question 1
MS Query and date format 3
Excel CSV Files; Creating Of 3
Excel And Notepad 3
.csv Format, Hidden Columns, 2007 2
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
CSV->Excel Data Problem 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0

Back
Top