Hi Chris,
An alternative way is to make a read/write cursor with a memo field and store the data in the memo field in the correct order. Then print the cursor to text.

This way would also work if you needed to produce multiple versions of the text file (for example one for each header record in a table)

HTH
Barbara

>Any ideas on how to tackle this one? It's twisting my melon real bad...!
>
>I need to copy to a text file the contents of three tables. The first table contains the first line of the text file - a header. The second table contains multiple lines of information that needs to appear one following the next and the third table contains a footer line.
>
>I have been experimenting with COPY TO WITH DELIMITED BLANK but it is not working on several fronts...
>
>1. I SELECT each table in turn and COPY TO but it overwrites the file each time and I end up with only the footer...
>2. Theresulting text file contains spaces between the fields and character fields have quotes - both of which I need to remove.
>
>I guess what I need to do is either get the data in better shape before writing to the text file or alternatively, find a way of manipulating the text file...
>
>Thanks in advance...