Thank you for the solution.

Now, imagine that I need a "bookmark" in the beggining and the end of each
table. How to insert it?
Thanks!

Example:

*TABLE1*
1,2,3
2,3,4
*EOF*

*TABLE2*
1,2,3,4
2,3,4,5
*EOF*

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

It doesn't matter that the tables have differing structures if you want to
export a query containg columns from each of them..

Do you want the text file to look something like this though

col1, col2.col3
1,2,3
2,3,4
col1,col2,col3,col4
1,2,3,4
4,5,6,7
8,9,8,7
col1,col2,col3,col4,col5
1,2,3,4,5
2,3,4,5,6



For this solution I would pump each table to a seperate text file then use
the DOS COPY command

COPY file1.txt + file2.txt + file3.txt FileAll.txt



--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"Eduardo Greco" <Eduardo Greco (AT) discussions (DOT) microsoft.com> wrote

table2 has three fields.