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 GourgiHi Roy
That does not look like SQL Server syntax, which DBMS are you using? If you
are using SQL Server check out the utilities BCP or DTS to do this for you.
John
"Roy Gourgi" wrote:

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