Importing Text file data into Access decimal field

[djpearce]

Hi. I receive a text file from a mainframe. It contains decimal amount (e.g. 14.99) recorded in the text file as 1499. When I import the test file in a field formated for 2 decimal, I get 1499.00.

I have gone around this by writing a query to divide by 100. However, is there a clean way to bring in 1499 as 14.99? I tried using both a new table and an existing table with formats

 

[djpearce]

No. There are lots of options for date field formats but Access expects decimal points. It doesn't recognize assumed decimal positions as mainframe languages do.

Hey Pat,
Thanks for saving me the time. No need for "a better way" to do this, then.