Thanks Sergey
Just tried it on a small table. Looks like it is the way to go. A lot simplier than text-endtext.

Thanks again
Gaylen



>Hi Gaylen,
>
>We have a similar application and we're using COPY TO SDF, FILETOSTR and STRTOFILE. It works quite well and easy to debug and support.
>
>>I need to create an ascii file. The data for the ascii file is contained in a number of tables as follows.
>>
>>*Header line - info comes from policy master file table
>>*next line is policy information for policy identified in header record - info comes from policy detail table
>>*next line is location information for policy identified in header - info from policy location table
>>In all there are about 7 different lines of information associated with the header line. Then another header record for another policy and all the associated detail and so on until all policies are reported.
>>
>>I have considered using "Text - Endtext" and "copy to xxxx sdf" to create the ascii file with my preference being "text-endtext".
>>
>>Before I start, I was wondering if anyone had any other suggestion that I should consider.
>>
>>Thanks in advance.
>>
>>Gaylen
>>
>>
>>
>>
>>
>>
>>Each line in the file has a different format