You can use FILETOSTR()/STRTOFILE() combination to add files to the end of the result file.

SELECT table1
COPY SDF TO (lcAsciiFile)
SELECT table2
COPY SDF TO (lcTempFile)
STRTOFILE(FILETOSTR(lcTempFile), lcAsciiFile, .T.)
SELECT table3
COPY SDF TO (lcTempFile)
STRTOFILE(FILETOSTR(lcTempFile), lcAsciiFile, .T.)
ERASE (lcTempFile) 

>I have three table from which i need to make an ascii file. All the records in the first table followed by all the records in the second table etc. All the table have different structures. I assumed I could use the copy to command with a type of sdf. However using the copy to on the second table overwrites the txt file from the first copy to. I did not see an additive command or anything like that.
>
>Any other ideas are welcome.
>
>Thank
>Gaylen