Debbie,

Here is a TSQL code snippet which might help;

DECLARE @bcpResult INT

DECLARE @bcpCommand

NVARCHAR(4000)

 SET @bcpCommand = 'bcp select * from Accounts queryout c:\temp\test.csv -U username -P password -c'

 -- Export to CSV 

 EXEC @bcpResult...