MSSQL 2008 isql commnd line export to CSV specifying double quotes around alpha fields
Posted on 2014-10-28
Hello. Like it sez...using ISQL to export to CSV for later import into Excel; works fine unless agents put commas in text fields. I understand that somehow I can specify double quotes around alpha fields from the command line, but cannot locate info on how. -s doesn't work, since double quotes are misinterpreted by the batch file that runs the query in Automate.
So...is there a command line parameter that will specify double quotes around alpha fields to give me "," delimiting around them? CUrrent command line:
isql.exe -d tt20%logYear%_%logMonth% -h 0 -i %directory%\8230YCC.sql -S data_base77 -s "," -U sa -P ******* -n -w 1024 >> %directory%\asiexport.csv