| Author |
 Topic  |
|
|
sachingovekar
Yak Posting Veteran
97 Posts |
 Posted - 10/22/2012 : 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 city
rick 2nd, ringtownstreet,23 singapore
Regards,
Sachin |
|
|
jackv
Flowing Fount of Yak Knowledge
United Kingdom
1795 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
India
48101 Posts |
Posted - 10/22/2012 : 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 city
rick 2nd, ringtownstreet,23 singapore
Regards,
Sachin
why not use text qualifer like "" to enclose the data with comma within it
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
 |
|
|
Lumbago
Norsk Yak Master
Norway
3246 Posts |
Posted - 10/23/2012 : 09:36:55
|
...or use a tab-delimiter...or semicolon or the vertical bar even ( | )...
- Lumbago
My blog-> http://thefirstsql.com |
|
|
| |
Topic |
|
exporting data into a csv file - cells get shifted
