Rounding error when importing from Excel

  • Thread starter Thread starter Barbara Biddle
  • Start date Start date
B

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?
 
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?
Click to expand...

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
 
Back
Top