Post reply

How to pass text delimiter in bcp command

  • September 26, 2018 at 12:32 am

    #373223

    I am facing one issue while loading data from file to table. our field separator is "," but in text columns having "," in between data, IN BCp Command, How to pass text delimiter as " " to ignore comma between data ?

    bcp test.dbo.table in "c:\sa.txt" -T -t, -c

  • September 26, 2018 at 7:24 am

    #2007073

    You may need a format file to allow BCP to properly deal with quoted strings, but I don't know BCP well enough to know for sure.   Look at Microsoft's documentation on BCP and you can find the specifications for a FORMAT file.

    Steve (aka sgmunson) 🙂 🙂 🙂
    Rent Servers for Income (picks and shovels strategy)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply