>I need to add records to a database table (with some modifications) from an ASCII comma delimited file created by another application. How do you do this?

With some modification? I would suggest 2 tables, one that is populated directly from an APPEND FROM and one that is populated from the first table, but with your modifications. A SQL INSERT or SCAN with an APPEND BLANK, standard stuff should do it.