exporting SQL tables

Hello:
I am familiar with SQL 2000's Export wizard in terms of exporting data to a
csv or a text file.
Is there any way to export more than one table at a time, though, other than
through something like BCP?
Let's say that you were to use BCP, to export more than one table at a time.
In SQL 2000, when you use BCP to export one or more tables, how would you
get the column headers to show in the exported file?
childofthe1980sHi
If you just want the data then you would not need column headers!
See if http://www.sqldts.com/299.aspx does what you want!
John
"childofthe1980s" wrote:
> Hello:
> I am familiar with SQL 2000's Export wizard in terms of exporting data to a
> csv or a text file.
> Is there any way to export more than one table at a time, though, other than
> through something like BCP?
> Let's say that you were to use BCP, to export more than one table at a time.
> In SQL 2000, when you use BCP to export one or more tables, how would you
> get the column headers to show in the exported file?
> childofthe1980s