Mess-up When Exporting to an Excel in Query Analyzer
 

Hi All,

I want to export the output from Query Analyzer to an Excel file (a CSV
file).

However, because I have comma (",") in certain data, these data are
split between separate columns. I want to set "Fixed width" in
"Data-Text to Column" in Excel file. However, that doesn't seem to
work, because the data are still split.

Anyone can advise me on how to export the data from Query Analyzer
properly to an Excel file?

Would truly appreciate it!

-Emily

Mess-up When Exporting to an Excel in Query Analyzer
 

Which Query Analyzer are you talking about ? The one from SQL Server ?
Normally a value containing a comma is enclosed in quote marks for CSV
files, so it is not a problem. SQL server should do this, I would have
thought.
If not, then export with a different delimiter; tab, semi-colon, pipe etc.
Or if you data really is fixed-width, then use that.

NickHK

"Emily" wrote in message
ups.com...
Hi All,

I want to export the output from Query Analyzer to an Excel file (a CSV
file).

However, because I have comma (",") in certain data, these data are
split between separate columns. I want to set "Fixed width" in
"Data-Text to Column" in Excel file. However, that doesn't seem to
work, because the data are still split.

Anyone can advise me on how to export the data from Query Analyzer
properly to an Excel file?

Would truly appreciate it!

-Emily