exporting to CSV

I have a need to run an export of fields from a table into a CSV text file located on my e:\exports. Is there a simple way to do this?

Hi jim,

Why cant you use DTS service to transfer the tables datas into CSV file ?

|||

use the following query...

master..xp_cmdshell 'bcp "select * from master..sysobjects" queryout e:\exports\exported.csv -SMYSERVER -UMyUserName -pMyPassword -c -t "," -r "\n"'

|||thanks I will do!