>IIRC, it's long standing bug or feature of APPEND TYPE CSV. You can use TYPE DELIMITED to avoid this problem

>APPEND FROM fubar.txt TYPE DELIMITED


Unfortunately; that will not work ... .the real records being imported are like

First,Last,Middle,DOB,Street,City,State,Phone,Zip,PHone2,enrollment,Somethingelse

so a data record is:

Joe,Smith,,01/01/01,,,,,,,1/01/2003,something

Doing "delimitited" gives problems with ",,,"