I have used the TEXT MERGE abilites of VFP to create delimited files of multiple tables. I delimit fields with the tilde character [~] which preevents problems with fields that have the full quote marks like 4" x 2" x 8'

>I'm looking for recommendations for creating ASCII delimited text files. The text file I must create consist of two different record formats. The records for each format exist in separate tables and must be combined in one ASCII delimited file.
>
>Example...
>
>"hdrRecord","field1","field2"
>"DetailRecord","Field1","field2",etc..
>
>The delima I have is creating one file with both record types using SQL Select or the COPY TO command. I have tried using the COPY TO command but it will not allow me to append the two files. I tried using SQL to combine the two tables into a third with one large field that contains the records in the ASCII format. Then when I use the COPY TO command on combined table to a dbf with the option DELIMITER BLANK the text file contains an extra set of quotation marks. The SQL SELECT with the ADDITIVE PLAIN options does append the two files but the file contains leading spaces.
>
>Are there file processing capabilites in Visual Fox 6.0 that will allow me to do this or can you suggest other commands that might accomplish this easily?
>
>Thanks for your input