USE
数据库名
BULK Insert dbo.表名
From ' c:\CSV文件名.csv '
WITH (
FIELDTERMINATOR = ' , ' ,
ROWTERMINATOR = ' \n '
)
BULK Insert dbo.表名
From ' c:\CSV文件名.csv '
WITH (
FIELDTERMINATOR = ' , ' ,
ROWTERMINATOR = ' \n '
)
就这么简单
转载于:https://www.cnblogs.com/bankey/archive/2007/11/23/969910.html