SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 exporting data into a csv file - cells get shifted
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sachingovekar
Yak Posting Veteran

99 Posts

Posted - 10/22/2012 :  08:58:14  Show Profile  Reply with Quote
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
2062 Posts

Posted - 10/22/2012 :  09:42:40  Show Profile  Visit jackv's Homepage  Reply with Quote
Have you specified the delimiter?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 10/22/2012 :  13:23:17  Show Profile  Reply with Quote
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/

Go to Top of Page

Lumbago
Norsk Yak Master

Norway
3271 Posts

Posted - 10/23/2012 :  09:36:55  Show Profile  Reply with Quote
...or use a tab-delimiter...or semicolon or the vertical bar even ( | )...

- Lumbago
My blog-> http://thefirstsql.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.27 seconds. Powered By: Snitz Forums 2000