Mess-up When Exporting to an Excel in Query Analyzer

  • Thread starter Thread starter Emily
  • Start date Start date
E

Emily

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Export Gmail Emails to PST Format? 4
delimited text export 3
How to export a range to CSV 3
Create a comma-delimited file to be opened in Excel 5
export data between spreadsheets 2
Export of select query data to excel in Access 2007 4
How to split an excel workbook in code and data 2
Automate Excel export to a CSV file 1

Back
Top