Rounding error when importing from Excel

[Barbara Biddle]

I am developing a database. When I get the external data
from an Excel spreadsheet, the number fields are rounding
up ex:10.5200 appears in the table as 11.0000 and a value
of 3.5 becomes 3. I have checked the imput mask and the
value. Any clues?

 

[John Nurick]

Hi Barbara,

One possible cause is that you are importing the numbers into Long or
Integer numer fields in Access. These can only store whole numbers. If
that's the case, change the design of your tables so that these fields
are Number(Double).

I am developing a database. When I get the external data
from an Excel spreadsheet, the number fields are rounding
up ex:10.5200 appears in the table as 11.0000 and a value
of 3.5 becomes 3. I have checked the imput mask and the
value. Any clues?

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.