View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Emily[_3_] Emily[_3_] is offline
external usenet poster
 
Posts: 25
Default 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