John W. Colby
jwcolby at colbyconsulting.com
Sun Sep 5 20:41:24 CDT 2004
BTW my BCP query looks like: BULK INSERT conduit..conduit FROM 'z:\Conduit001.txt' WITH ( DATAFILETYPE = 'char', FIELDTERMINATOR = ',', ROWTERMINATOR = '\n' ) 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 John W. Colby Sent: Sunday, September 05, 2004 8:37 PM To: dba-sqlserver at databaseadvisors.com Subject: [dba-SQLServer] Quotes in data part II 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. John W. Colby www.ColbyConsulting.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com