Text file import with mixed data

[JHL]

I have a rather large text file and because of the way the data is
retrieved, some columns have alpha and numeric data. The alpha characters
will always be "NF" (without the quotes). The numeric will be in dollar
format.
When you import the only way I know of so that I do not lose the "NF"
records, is to format those columns as text. My problem is I do need to
make calculations on those other records.

All help is appreciated.
JHL

 

[Ken Snell \(MVP\)]

Check out Import Specification in Help file; you can create and store a
specification and then use it with TransferText action / method to import
data from a text file.