Saturday, March 14, 2015

批量导入.dat 文件进入sql server

先create table,确保和dat文件的数据格式一直

在在query里面
BULK INSERT table_name
   FROM 'D:\data.DAT'
   WITH 
      (
         FIELDTERMINATOR =',',   //分隔符
         ROWTERMINATOR ='\n'  //换行
      )

No comments:

Post a Comment