Import trouble from Excel to Access

[kathleen]

I have a file that contains about 300 rows of data. The
columns contain numbers with 6 digit decimal points, and
some other columns contain numbers, some contain text.
Each time I import into Access (Access 2002) I get the
data BUT the columns that contain the #'s with the 6
digit decimal points are truncated to 2 decimal points
only. I tried converting the Excel file to .txt first
but the decimal number is truncated in Excel to two
decimal points! I also tried to design a table in Access
first, with the formatting for numbers with 6 decimal
points.

Thanks