CSV文件导入数据库
现在要将CSV文件导入到SQL SERVER数据库
请大家帮帮忙,谢谢
[解决办法]
- SQL code
LOAD DATA LOCAL INFILE 'D:\LineStops.csv'INTO TABLE linestops FIELDS TERMINATED BY ',' ENCLOSED BY """" LINES TERMINATED BY '\r\n';
发布时间: 2012-02-04 15:43:08 作者: rapoo
CSV文件导入数据库
现在要将CSV文件导入到SQL SERVER数据库
请大家帮帮忙,谢谢
[解决办法]
LOAD DATA LOCAL INFILE 'D:\LineStops.csv'INTO TABLE linestops FIELDS TERMINATED BY ',' ENCLOSED BY """" LINES TERMINATED BY '\r\n';