title: SQL Server CSV extract of tables with newline, doublequotes and commas in columns?
body: <p>I extracted some 10 tables in CSV with " as the text qualifier. Problem is my extract does not look right in Excel because of special characters in a few columns. Some columns are breaking into a new row when it should stay in the column.</p>
  
  <ol>
  <li>I've been doing it manually using the management studio export feature, but what's the best extract the 10 tables to CSV with the double quote qualifier using a script?</li>
  <li>Will I have to escape commas and double quotes? Best way to do this?</li>
  <li>How should I handle newline codes in my columns, we need them for migration to a new system, but the PM wants to open the files and make modifications using Excel. Can they have it both ways?</li>
  </ol>
  
  <p>I understand that much of the problem is that Excel is interpreting the file where a load utility into another database might not do anything special with new line, but what about double quotes and commas in the data, if I don't care about excel, must I escape that?</p>
  
  <p>Many Thanks.</p>