>Hi All
>For data manipulation I have to import fixed width text files to VFP free table. It works ok when the each row width in the text file is less than 255 (CH). I use an empty table with single field 254 CH and then I use APPEND FROM textfile DELIMITED and then I use SUBSTR() to get the required fields to append another table...
<snip>


>When the row width in the text file is more than 254 Ch then I can not get complete line of the text due to field width 254 CH. I want to save each text file line in a single record with more than 254 Ch.

Zaheer, some questions:

1) Can you post a small example of the text file format you are importing?
2) Is each line in the text file a single field of text or multiple field items?
3) If a single line of text then use a memo field rather.
4) You can also look at using LLFF to read the file in but start with posting a short example of the file to be imported.