Using Spaces for Delimiters in Data Files

Using spaces for delimiters while using bcp does not work. There are two options you can take to correct this problem:

• Change the delimiter from a space to a nonspace character.
• Reformat the data file to be of fixed-length columns.