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...