>Bruce
>
>The fields are fixed length so the info for field 1 in my table will always be be the first 20 characters of the text, field 2 will be the next 20 & so on...what I really need to do (I think) is somehow extract the first 20 characters so I can allocate them to field 1, the next 20 so I can allocate them to field 2 & so on...at the moment the system wants to dump everything into the first field in my table...

Hi Chris:

PMFJI: At our location, the FoxPro system is an alternate storehouse for lots of data from mainframe and minicomputer systems, and virtually all incoming files are in ASCII text format, fixed length (SDF). We process hundreds of thousands of records of data that way every night, with no problems (other than network infrastructure...). I agree with Bruce that your most likely problem is just the 'fields' clause usage. Forget it. All our stuff just has an empty DBF structure and we run 'APPEND FROM xxxx TYPE SDF' for each of the incoming text files. At least a few of them are in excess of 2048 bytes per record. The 255 limit is for an individual field width, I think, and you can even get around that by making two fields and concatenating them for data manipulation...

Gonzo's technique is also a good one, but we like to work just on the DBFs (cause we're wimps on that low-level stuff...).

HTH

Rob