Hi John

No, there are no memo fields in the target table. I do think that I'm approaching the problem the wrong way though - I'm using the command

APPEND FROM TEXTFILE.DAT TYPE SDF FIELDS MYTABLE.Account_no, MYTABLE.Acc_name, etc etc

The problem is that the system trys to dump all the info into the first field "Account_no" and nothing into the next fields. I actually want the first 20 characters of the text line placed into field 1, the next 20 into field 2 etc...

It works fine when it's comma delimited, but not in the flat file format.

Regards


Chris