How can you specify a text qualifier for char field in a format file when outputting table data to a text file using BCP?

You need to treat the text qualifier as part if the column delimiter.
Instead of using , try "," for example to close and open two adjacent text
qualified fields. There are some issues with this method, but it is the best
method available when using BCP. If using DTS then the Text File Provider
fully supports text qualifiers. another alternative is to use a query (see
queryout) and include the text qualifiers in the SELECT.

--
Darren Green
http://www.sqldts.com

"JoeD" <anonymous (AT) discussions (DOT) microsoft.com> wrote

you can also set the text qualifier via an ActiveX script relatively easily

"JoeD" <anonymous (AT) discussions (DOT) microsoft.com> wrote