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.