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.