Importing a text file without decimals

[Guest]

I am importing a text file in to Access 2002. The file I am importing
contains numbers that are thirteen digits long with no decimals, but it is
currency. The last two digits are to be on the right of the decimal (cents),
but when I import the file I can not get the decimal to appear in the table.

When I import the text file how do I cause the decimal to be in the table in
the appropriate location?

 

[John Nurick]

Hi Amshly,

One way to do this is temporarily linking or importing the file to one
table, and then using an append query to move the data into the
"permanent" table.

In the append query, use a calculated field, e.g
fCurrencyField: [CurrencyField] / 100
to shift the decimal point two places to the left. Remember that you
should use a Currency or Double field type when you need to store
decimals.