Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sachingovekar
Posting Yak Master
101 Posts |
 Posted - 2012-10-22 : 08:58:14
|
| Hi,I am trying to export data from sql server 2008 table into csv file using import\export wizard.when i open the csv file, the cells are shifted.The problem is my address column has "comma".data is in this format:name address cityrick 2nd, ringtownstreet,23 singaporeRegards,Sachin |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-10-22 : 09:42:40
|
| Have you specified the delimiter?Jack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-10-22 : 13:23:17
|
quote:
Originally posted by sachingovekar
Hi,I am trying to export data from sql server 2008 table into csv file using import\export wizard.when i open the csv file, the cells are shifted.The problem is my address column has "comma".data is in this format:name address cityrick 2nd, ringtownstreet,23 singaporeRegards,Sachin
why not use text qualifer like "" to enclose the data with comma within it------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2012-10-23 : 09:36:55
|
| ...or use a tab-delimiter...or semicolon or the vertical bar even ( | )...- LumbagoMy blog-> http://thefirstsql.com |
|
|
|
|
|
|
exporting data into a csv file - cells get shifted