John W. Colby
jwcolby at colbyconsulting.com
Sun Sep 5 20:40:57 CDT 2004
>Yep, it's a very common convention to quote all strings in CSV files. You always need to check your data format and define the appropriate import method before working with any text import method. Well that's the thing, I know NOTHING about this stuff. The DTS handled it correctly. I didn't (still don't) see any parameters to BCP to tell it to get rid of the quotes. I thought BCP would work just like DTS. Not so apparently. John W. Colby www.ColbyConsulting.com -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan Sent: Sunday, September 05, 2004 9:32 PM To: dba-sqlserver at databaseadvisors.com Subject: Re: [dba-SQLServer] Quotes in data part II On 5 Sep 2004 at 20:37, John W. Colby wrote: > I assume that the quotes are a valid strategy to allow commas to be > embedded in the data, i.e. if the comma is inside a pair of quotes it > is data, if it is outside, it is a field delimiter? > > Argh. Sigh. Beats head against sharp corner of filing cabinet. > Yep, it's a very common convention to quote all strings in CSV files. You always need to check your data format and define the appropriate import method before working with any text import method. Even the Access Import text Wizard has a selection box for "Text Qualifier" which offers the choice of double, single quotes or "~none~" -- Stuart _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com