导入文本文件的问题

Question

以下为fmt格式文件，请帮我看看哪里不对，还有bcp的参数怎么写？哪些是必须的参数？多谢了
8.0
21
1       SQLNCHAR      0       2       ""                        1     海关代号      Chinese_PRC_CI_AS
2       SQLNCHAR      0       1       ""                        2     进出标志      Chinese_PRC_CI_AS
3       SQLNCHAR      0       9       ""                        3     报关单编号    Chinese_PRC_CI_AS
4       SQLNCHAR      0       1       ""                        4     保留位        Chinese_PRC_CI_AS
5       SQLNCHAR      0       2       ""                        5     商品项号      Chinese_PRC_CI_AS
6       SQLNCHAR      0       10      ""                        6     经营单位编号  Chinese_PRC_CI_AS
7       SQLNCHAR      0       5       ""                        7     收发货地      Chinese_PRC_CI_AS
8       SQLNCHAR      0       2       ""                        8     贸易方式代号  Chinese_PRC_CI_AS
9       SQLNCHAR      0       3       ""                        9     起抵国别      Chinese_PRC_CI_AS
10      SQLNCHAR      0       3       ""                        10    最终目的原产国 Chinese_PRC_CI_AS
11      SQLNCHAR      0       1       ""                        11    运输方式      Chinese_PRC_CI_AS
12      SQLNCHAR      0       1       ""                        12    保留字段      Chinese_PRC_CI_AS
13      SQLNCHAR      0       8       ""                        13    商品编号      Chinese_PRC_CI_AS
14      SQLNCHAR      0       11      ""                        14    第一数量      ""
15      SQLNCHAR      0       2       ""                        15    第一单位      Chinese_PRC_CI_AS
16      SQLNCHAR      0       11      ""                        16    人民币值      ""
17      SQLNCHAR      0       11      ""                        17    美元值        ""
18      SQLNCHAR      0       2       ""                        18    第二单位      Chinese_PRC_CI_AS
19      SQLNCHAR      0       11      ""                        19    第二数量      ""
20      SQLNCHAR      0       4       "\r\n"                    20    fill-4       Chinese_PRC_CI_AS
21      SQLNCHAR      0       0       ""                        0     日期          ""

Answer 1

解决拉！
1、用 OPENROWSET
declare @iid int,@iisql varchar(8000)set @iid=200301while @iid<=200302
begin
set @iisql='insert into [tj].[dbo].[sqltable] select * from  OPENROWSET(''MICROSOFT.JET.OLEDB.4.0'',''Text;Database=E:'',''SELECT * FROM ['+ convert(char(6),@iid) +'#txt]'')' 
exec(@iisql)
end
2、用'BULK INSERT 
declare @iid int,@isql varchar(8000)
set @iid=200301while @iid<=200302
beginset @isql='BULK INSERT tj..模板 FROM ''E:'+ convert(char(6),@iid) + '.dat'' WITH(FORMATFILE = ''E:\llww.fmt'')'
exec(@isql)