By changing the default values of the prompts to bcp, you can prepare data for use with other software.
To create a human-readable file, respond to the bcp prompts as follows:
File storage
type, enter 0.
Prefix length, enter 0.
Field length, accept the default.
Terminator – the field terminator you enter depends on the software that you plan to use.
Choose between delimited fields or fixed-length
fields. Always use \n,
the newline terminator, to terminate the last field.
For fixed-length fields, do not use a terminator. Each field has a fixed length, with spaces to pad the fields. Adjacent fields, where the data completely fills the first field seem to run together, since there are no field separators on each line of output. See the example below.
For
comma-delimited output, use a comma (,)
as the terminator for each field. To create tabular output, use
the tab character (\t).
