MS Access Database with External Data - Import excel into Accees problem with too many decimal places

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Import excel into Accees problem with too many decimal places

robertrobertrobertrobert

2005-09-30, 7:24 am

Unfortunately their are not more 30 decimal places in excel when viewing a
CSV file and the numbers only appear as 120.000000000000000etc. I have opened
the CSV file in note pad and again there are only 1 to 2 decimal places.
however if I auto sum the column the value would be 5700.950000010000etc. by
highlighting row by row using the auto sum at the bottom of the screen I can
see when the decimal places are more than 2 however the value in question
still shows two decimal places.
The data is very large and I would like to round all values down to 2
decimal places easily before importing.

Thanks

"dlw" wrote:
[color=darkred]
> What does the number in the CSV file look like? You probably need to
> =round() before importing. Changing the format does nothing to the number,
> it just changes how it is displayed.
>
> " robertrobertrobertro
bert" wrote:
>

Sponsored Links