YCH
SSC Eights!
Points: 892
More actions
September 18, 2002 at 7:02 pm
#79462
I am trying to import a text file by using bcp. How do I specify the text qualifier (i.e. double quote) in the bcp format file? Thanks.
Chris Hedgate
One Orange Chip
Points: 25041
September 19, 2002 at 2:04 am
#436828
If I understand your question correctly, you have used double quotes as text qualifiers in your file or query, and you want to specify bcp to use them. If so, the parameter is -q.
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
http://www.sql.nu
--Chris Hedgate http://www.hedgate.net/Contributor to the Best of SQL Server Central volumesArticles: http://www.sqlservercentral.com/columnists/chedgate/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply