I need to import data from a text file. Two of the fields are currency amounts. However, the last two characters of these two fields are the cents and I need Access to add a decimal in that spot. That makes a difference between $1.00 and $100. The file (attached) is a fixed width file from our in house software.
The fields are:
FIELD START FORMAT
ACCTNUM 1 X(17)
PAYREF 18 X(30)
POSTDATE 48 YYYYMMDD
DRAMT 56 999999999
CRAMT 65 999999999
The last two digits of the CRAMT and DRAMT are the "cents" of the amts. All amounts are (+) in value. Example: 000015025= $150.25
How can I get access to add this decimal into the correct position? I have tried the "Advanced" option, but it is still importing 000015025 as $15,025.00.