Hi;

Is there any way to export a view to a .csv file in SQL 2000.
I am looking for an equivalent of the below in Oracle.

SQL> spool c:\myfile.csv

Many Thanks in Advance.

________________________________


Regards;
Jyothish John

Telkom SA ITX,
179, Proes Street,
Pretoria,
South Africa.

Phone : +27 (0)12 321 1977
Cell : +27 (0)82 499 3007
Fax : +27 (0)12 311 3742
Email : [Email address protected]
Website : www.telkom.co.za


________________________________








==================================================================
This e-mail and its contents are subject to the Telkom SA Limited
e-mail legal notice available at
http://www.telkom.co.za/TelkomEMailLegalNotice.PDF

MS Sql Server LazyDBA home page