To copy in data successfully to a table from a file, you must know what the terminators in the file are or what the field lengths are and specify them when you use bcp.
The following examples show how to copy data in, either with fixed field lengths or with delimiters, using bcp with or without a format file.
