Specify column separator for BCP -

how specify column separator "," bcp or code below

bcp [wwtest].[accesscontrol].[roles] out c:\test\bcp_outputtable.csv -spc01 -t -c  

try adding -t, . see following documentation : https://msdn.microsoft.com/en-us/library/ms191485.aspx , https://msdn.microsoft.com/en-us/library/ms162802.aspx