>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...
You have to create a temporary table or cursor, which will have exactly these widths, and the names you need, and then append SDF from the textfile into that table, then select your target table and append from this temp table - it will go name by name into the corresponding fields.