将 CSV 导入 SQl Server 2005 的最简单方法
我有几个大约 5k 的 CSV 数据文件,需要导入到 SQL Server 2005 中。
过去使用 DTS 很简单。我之前尝试过使用 SSIS,但似乎要付出大约 10 倍的努力,最终我放弃了。
将 csv 数据导入 sql server 的最简单方法是什么?理想情况下,工具或方法也会创建表,因为其中大约有 150 个字段,这会简化事情。
有时,对于这些数据,可能需要手动修改 1 或 2 行,因为它们未正确导入。
I have several files about 5k each of CSV data I need to import into SQL Server 2005.
This used to be simple with DTS. I tried to use SSIS previously and it seemed to be about 10x as much effort and I eventually gave up.
What would be the simplest way to import the csv data into sql server? Ideally, the tool or method would create the table as well, since there are about 150 fields in it, this would simplify things.
Sometimes with this data, there will be 1 or 2 rows that may need to be manually modified because they are not importing correctly.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
试试这个:
http://blog.sqlauthority.com/2008/02/06/sql-server-import-csv-file-into-sql-server-using -bulk-insert-load-comma-delimited-file-into-sql-server/
这里是链接中代码的摘要:
创建表:
导入数据:
使用表的内容:
try this:
http://blog.sqlauthority.com/2008/02/06/sql-server-import-csv-file-into-sql-server-using-bulk-insert-load-comma-delimited-file-into-sql-server/
here is a summary of the code from the link:
Create Table:
import data:
use the content of the table: