Excel won't open Unicode CSV file from SQL Server

[kwdavids]

I have a CSV file created by Microsoft SQL Server Management Studio in
Unicode (that's all it can do). The file is just some numbers, nothing
fancy. But when I attempt to open the CSV file with Excel 2007, all
the columns are thrown into the first column.

I can manually import the CSV file, through the wizard, tediously
navigating to the file, and specifying delimiters, but that's a pain
to do over and over again.

All I want to do is save a result set in SQL Server and open in in
Excel. Is that too much to ask?

Kevin

 

[Harlan Grove]

I have a CSV file created by Microsoft SQL Server Management Studio
in Unicode (that's all it can do). The file is just some numbers,
nothing fancy. But when I attempt to open the CSV file with Excel
2007, all the columns are thrown into the first column.

....

You could fix this from the command prompt. The command

type your-filename-here.CSV > your-filename-here..CSV

will create a plain text CSV file (note the 2 periods - INTENTIONAL!)
from your Unicode CSV file assuming your Windows Regional Settings
locale doesn't use Unicode encoding by default. Then open the derived
CSV file in Excel.

 

[kwdavids]

...

You could fix this from the command prompt. The command

type your-filename-here.CSV > your-filename-here..CSV

will create a plain text CSV file (note the 2 periods - INTENTIONAL!)
from your Unicode CSV file assuming your Windows Regional Settings
locale doesn't use Unicode encoding by default. Then open the derived
CSV file in Excel.

What I did was to change my file extension mapping for CSV from Excel
to OpenOffice. OpenOffice knows how to open Unicode CSV files when you
double-click on them.