COPY to a .txt file

Hi,
How do I copy the rows in my table into a .txt file comma delimited.
I tried COPY mytable TO '/presentation/myfile' WITH DELIMITER ','
but it does not work
TIA
Roy GourgiThat's because SQL Server is not FoxPro<g>. Take a look at the Import /
Export wizard. You can get to it in Enterprise Manager by choosing Tools /
Import/Export.
Andrew J. Kelly SQL MVP
"Roy Gourgi" <royng@.videotron.ca> wrote in message
news:KO45g.43$hR6.20646@.weber.videotron.net...
> Hi,
> How do I copy the rows in my table into a .txt file comma delimited.
> I tried COPY mytable TO '/presentation/myfile' WITH DELIMITER ','
> but it does not work
> TIA
> Roy Gourgi
>|||You can create txt file using SQLCMD.
that is simmiliar to osql utitilty.
"Roy Gourgi"?? ??? ??:

> Hi,
> How do I copy the rows in my table into a .txt file comma delimited.
> I tried COPY mytable TO '/presentation/myfile' WITH DELIMITER ','
> but it does not work
> TIA
> Roy Gourgi
>
>