Writing to a text file from a database query.

[Stefan]

I need to just back one table and not all the data in the table. Is there a
way to have SQL save the data return from a query to some text file that I
can then use to build the table in another table on another server?

I am SQL server 7

Thanks,

S

[Simon Hayes]

"Stefan" <ni***@studioweb.com> wrote in message news:<Dr******************@news20.bellglobal.com>. ..

I need to just back one table and not all the data in the table. Is there a
way to have SQL save the data return from a query to some text file that I
can then use to build the table in another table on another server?

I am SQL server 7

Thanks,

S

There are several different options - osql.exe, bcp.exe, or DTS. bcp
is commonly used for this task.

Simon