Excel won't open Unicode CSV file from SQL Server

Giganews Newsgroups
Subject: Excel won't open Unicode CSV file from SQL Server
Posted by:  kwdavids (kwdavi…@gmail.com)
Date: Tue, 15 Jul 2008

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

Replies