Specify column separator for BCP

Question

How do I specify column separator with "," for bcp or this code below

bcp [wwtest].[accesscontrol].[Roles] out C:\test\bcp_outputTable.csv -SPC01 -T -c 

Answer 1

Try adding -t, . See following documentation : https://msdn.microsoft.com/en-us/library/ms191485.aspx and https://msdn.microsoft.com/en-us/library/ms162802.aspx