Take the 2-minute tour ×

When would we use a format file for bcp?

share|improve this question
add comment

1 Answer

up vote 2 down vote accepted

Usually, when you have different column separators.

For example: bob,"fred","tom"||harry rather than bob,fred,tom,harry

The section "When Is a Format File Required?" describes it completely

share|improve this answer
thank you very much gbn –  masoud ramezani Jan 3 '10 at 9:41
add comment

Your Answer


