Insert 文件 to table (DB)

1. 新建一个Table

CREATE TABLE TestTable(
ID int,
Name NVARCHAR(10)

)

2. New query

BULK Insert TestTable

from ‘D:\info.txt’

WITH(

   fieldterminator = ',',
   rowterminator = '\n'

)