SQL导入问题

可以直接导入的．．
先生成格式化文件：
tb.xml<?xml version="1.0"?>
<BCPFORMAT xmlns="http://schemas.microsoft.com/sqlserver/2004/bulkload/format" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
 <RECORD>
  <FIELD ID="1" xsi:type="CharTerm" TERMINATOR="\r\n" MAX_LENGTH="20" COLLATION="Chinese_PRC_90_CI_AS"/>
  <FIELD ID="2" xsi:type="CharTerm" TERMINATOR="\r\n" MAX_LENGTH="20" COLLATION="Chinese_PRC_90_CI_AS"/>
  <FIELD ID="3" xsi:type="CharTerm" TERMINATOR="\r\n" MAX_LENGTH="20" COLLATION="Chinese_PRC_90_CI_AS"/>
 </RECORD>
 <ROW>
  <COLUMN SOURCE="1" NAME="col1" xsi:type="SQLVARYCHAR"/>
  <COLUMN SOURCE="2" NAME="col2" xsi:type="SQLVARYCHAR"/>
  <COLUMN SOURCE="3" NAME="col3" xsi:type="SQLVARYCHAR"/>
 </ROW>
</BCPFORMAT>然后导入CREATE TABLE tb(col1 VARCHAR(20),col2 VARCHAR(20),col3 VARCHAR(20))
BULK INSERT tb
    FROM 'G:\tb.txt'
WITH
(
    FORMATFILE = 'G:\tb.xml'
);SELECT * FROM tb;/*
col1                 col2                 col3
-------------------- -------------------- --------------------
211000123456         00000008             20120008
211000123456         00000005             20120005
211000123456         00000007             20120007
211000123456         00000004             20120004
211000123456         00000001             20120001 (5 行受影响)*/DROP TABLE tb;