Importing Excel Spreadhseet loses data's decimal places

[tamula]

Hi,
When I use the "get external data" and import my data into a predefined
Access Table, the data loses it's decimalplaces. For instance, "1.00"
becomes "1" and no matter how I set the field properties in the table
and even the form I use to view the data, it still displays as "1".
What am I missing here? I'm guessing there's an easy fix, that's
eluding me? THANKS!
T. Lang

 

[Guest]

How it displays is not as important as the values themselves. For example,
does a value of 1.23 display as 1 or 1.23? You can effect the way a field
displays its data with the format property and the decimal places property,
but if it's truncating the data, that would be a problem.

Barry

 

[John Vinson]

When I use the "get external data" and import my data into a predefined
Access Table, the data loses it's decimalplaces.

That suggests that you may have used the default Number type - Long
Integer. Integers, by definition, have no decimal places.

Use either a Currency datatype (*not* Format, that just controls the
display) if you can get by with exactly four decimal places; or a
Float or Double datatype of Number.

John W. Vinson[MVP]