BCP SQL Command to .csv file has formatting issue

Question

I have a simple BCP command to query my MSSQL database and copy the result to a .csv file like this:

bcp "select fullname from [database1].[dbo].employee" queryout  "c:\test\table.csv"  -c -t"," -r"\n" -S servername -T

The issue comes when the fullname column is varchar separated by a comma like "Lee, Bruce". When the result is copied to the .csv file, the portion before the comma (Lee) is placed into the first column in Excel spreadsheet and the portion after the comma (Bruce) is placed in the second column. I would like it to keep everything in the first column and keep the comma (Lee, Bruce) . Does anyone have any idea how to achieve this?

Peter L. · Accepted Answer · 2013-02-12 14:44:52Z

2

Obviously you should set columns separator to something different than comma. I'm not familiar with the above syntax, but I guess these: -c -t"," -r"\n" are column and new line separators respectively.

Further you should either change default CSV separator in regional settings OR use import wizard for proper data placing in Excel. By the way, there are plenty of similar questions on SO.

answered Feb 12, 2013 at 14:44

Peter L.

7,3545 gold badges37 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

BCP SQL Command to .csv file has formatting issue

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related