implied decimal points in text files

J

Jonathan Oz

I am no doubt aging myself, but I recall in days of old that numeric data in
text files were often stored without the decimal point. This harkens back to
the bad-old-days of FORTRAN and such. I have a file with such data. I know
that I can import it as real, create a query that divides the number by 100
(for 2 decimal places) and then save the query as a table. That seems an
awful lot of bother. Is there a way to let Access XP know that the data has
an implied decimal point in the input process?
 
T

tina

AFAIK, there's no way to do it while using the Import Wizard, or a
TransferText action. rather than making an additional table from a
make-table query, though, you could import the data (making sure the field
in question is data type Double) and run an Update query on the original
table data, using the "divide by 100" solution.

hth
 
Top