|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?