CSV导入数据库-BULK INSERT

.fmt 格式

https://msdn.microsoft.com/ja-jp/library/ms191479.aspx

 

BULK INSERT TMP_TableName
FROM 'D:\temp.csv'
WITH (FORMATFILE = 'D:\csvformat.fmt' ,
FIRSTROW = 0 , MAXERRORS = 100 , KEEPNULLS , BATCHSIZE = 1000 ,
TABLOCK , DATAFILETYPE = 'WIDENATIVE')

csvformat.fmt'

9.0
3
1 SQLCHAR 0 100 "\t" 2 NO               ""
2 SQLCHAR 0 100 "\t" 3 NAME          ""

3 SQLCHAR 0 100 "\r\n" 4 AGE         ""

 

CREATE TABLE [dbo].[TMP_TableName](
 [SeqID] [int] IDENTITY(1,1) NOT NULL,--行号自增列
 [NO] [int] NOT NULL,
 [NAME] [varchar](12) NULL,
 [AGE] [varchar](12) NULL
) ON [PRIMARY]

GO 

 

https://msdn.microsoft.com/ja-jp/library/ms179250.aspx

http://blog.csdn.net/jackmacro/article/details/5959321

http://rsljdkt.iteye.com/blog/1147707