 | |
Stray control characters in CSV Export from Management Studio
microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools
 |
| | Thread Tools | Display Modes |
#21
 
| |||
| |||
|
Re: Stray control characters in CSV Export from Management Studio -
07-15-2008
, 05:32 PM
|
OK, I learned that the format is Unicode. Two things are broken in my mind. First SQL server can't save an ASCII CSV file. Excel is broken in that it can't open a Unicode CSV file. |
arror beside Save. Use this to select Save with Encoding.
I was able to open a CSV file in Unicode format with Excel 2007, but I
had to open it from within Excel. When I double-clicked it, I got
everything in column A.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
#22
| |||
| |||
|
|
OK, I learned that the format is Unicode. Two things are broken in my mind. First SQL server can't save an ASCII CSV file. Excel is broken in that it can't open a Unicode CSV file. |
arror beside Save. Use this to select Save with Encoding.
I was able to open a CSV file in Unicode format with Excel 2007, but I
had to open it from within Excel. When I double-clicked it, I got
everything in column A.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
#23
| |||
| |||
|
|
OK, I learned that the format is Unicode. Two things are broken in my mind. First SQL server can't save an ASCII CSV file. Excel is broken in that it can't open a Unicode CSV file. |
arror beside Save. Use this to select Save with Encoding.
I was able to open a CSV file in Unicode format with Excel 2007, but I
had to open it from within Excel. When I double-clicked it, I got
everything in column A.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
#24
| |||
| |||
|
|
OK, I learned that the format is Unicode. Two things are broken in my mind. First SQL server can't save an ASCII CSV file. Excel is broken in that it can't open a Unicode CSV file. |
arror beside Save. Use this to select Save with Encoding.
I was able to open a CSV file in Unicode format with Excel 2007, but I
had to open it from within Excel. When I double-clicked it, I got
everything in column A.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
#25
| |||
| |||
|
|
OK, I learned that the format is Unicode. Two things are broken in my mind. First SQL server can't save an ASCII CSV file. Excel is broken in that it can't open a Unicode CSV file. |
arror beside Save. Use this to select Save with Encoding.
I was able to open a CSV file in Unicode format with Excel 2007, but I
had to open it from within Excel. When I double-clicked it, I got
everything in column A.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
#26
| |||
| |||
|
|
OK, I learned that the format is Unicode. Two things are broken in my mind. First SQL server can't save an ASCII CSV file. Excel is broken in that it can't open a Unicode CSV file. |
arror beside Save. Use this to select Save with Encoding.
I was able to open a CSV file in Unicode format with Excel 2007, but I
had to open it from within Excel. When I double-clicked it, I got
everything in column A.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
#27
| |||
| |||
|
|
OK, I learned that the format is Unicode. Two things are broken in my mind. First SQL server can't save an ASCII CSV file. Excel is broken in that it can't open a Unicode CSV file. |
arror beside Save. Use this to select Save with Encoding.
I was able to open a CSV file in Unicode format with Excel 2007, but I
had to open it from within Excel. When I double-clicked it, I got
everything in column A.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
#28
| |||
| |||
|
|
OK, I learned that the format is Unicode. Two things are broken in my mind. First SQL server can't save an ASCII CSV file. Excel is broken in that it can't open a Unicode CSV file. |
arror beside Save. Use this to select Save with Encoding.
I was able to open a CSV file in Unicode format with Excel 2007, but I
had to open it from within Excel. When I double-clicked it, I got
everything in column A.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.