bulk insert的用法？(100分)

我用bulk insert导数据，
我试了一下：
如源表字段<目标字段，好象不行（是否正确？）
如源表字段=目标字段，但我要在每行后加上一个日期字段，有时行，有时不行（这是为什么？）
如源表字段>目标字段，没试，这种情况直接导行吗？

我在帮助里看bulk insert的属性，
有个
FORMATFILE [ = 'format_file_path' ]
Specifies the full path of a format file. A format file describes the data file that contains stored responses created using the bcp utility on the same table or view. The format file should be used in cases in which:
The data file contains greater or fewer columns than the table or view.
The columns are in a different order.
The column delimiters vary.
There are other changes in the data format. Format files are usually created by using the bcp utility and modified with a text editor as needed. For more information, see bcp Utility.
这里参数的作用是我需要的，
可我怎么生成这种文件啊？

没人知吗？

谁来get分，我想结束这个帖子