Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-11-30 : 00:00:17
|
| Robert writes "I'm using bcp in a stored procedure for the first time, and need the output to be in .csv (comma delimited) format.I've got that part ok using the delimiter tag, but the data I'm exporting has commas in it at times (e.g. name = "Doe,John"), and results in the output being parsed into too many columns: "Doe" and "John". I've used "quote strings" options in other apps to overcome this issue before, but am not seeing how to do it with bcp/SQL.Possible?Thanks!" |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
How do I get quotes around strings in bulk copy csv file? 