I am afraid that there is nothing more that you can do than writing a small application that will open the file and replace every return character with a space.

>I am trying to import a comma delimited text file to a table. One of the text field contains a return character. If I use append from it treats as a different record, could someone tell me is there some command I can use so it will import the data properly without writing a long program?