Trying to impot Excel file into a table

SteveL13
SteveL13 used Ask the Experts™
on
I have an Excel file that has a column of number that look like this:

1.0000
2.0000

And I'm trying to import them into a table but no matter what format I set that field up in the Access table it ends up looking like:

1
2

I need to import and show the decimals.  What am I doing wrong?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Brian PringleSystems Analyst II, SCM, ERP

Commented:
What data type did you declare in the table for that field?
Distinguished Expert 2017
Commented:
Long Integer is the default numeric data type.  Depending on what precision you need and how large the values will be you might use single, double, or currency.

I always use Currency  if I don't need more than four decimal digits since it avoids floating point errors which can be a problem with single and double.  Don't confuse the Currency data type with the Currency format.  The currency format is simply a scaled integer that always has 4 decimal places although you can set the display to fewer if you want.

Author

Commented:
Perfect.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial