bcp with quotes RRS feed

  • Question

  • Dear buddies,

    I am having a comma delimited data file created using bcp but I also need to include quotes for char fields.

    How can I go about it.

    I tried to use format file but still couldnt get it working.

    I tried using methods stated here as well: http://www.sqlservercentral.com/Forums/Topic457120-19-1.aspx

    but managed to get only some parts with quotes.


    Alagu, 20, running around

    So, I want it to be

    "Alagu", 20, "running around"

    Methods I tried definetely gave these output:

    Alagu","20","running around

    No quotes at the beginning and end.

    Please help me.

    Thanks a lot.

    Wednesday, June 9, 2010 10:30 AM


All replies