Importing Decimals to Access

[afa]

Currently, I am trying to import numbers such as 97.8 and 97.43 and 98 from Excel.


However, when imported to access the number values change to 978.00, 9743.00 and 98 respectively.

How do I fix this issue?

Thanks,

afa

[pbaldy]

What is the data type of the destination field? It can't be Integer or long Integer. I'd use Currency.

[ranman256]

import into a table already made with currency fields.