use NumberLocation;
BULK INSERT Fixed From 'E:\code\DB\fixedbook-sort.txt' With
(FIELDTERMINATOR = ',', ROWTERMINATOR = '\n')
其中 use 是先进入 数据库 NumberLocation
*.txt 是要导入的文本文件
FIELDTERMINATOR 是字段分隔符
ROWTERMINATOR 行分隔符
Dec 4, 2008
把文本文件中的数据导入 MS SQL Server 2005
在查询分析器中执行下面的命令：
use NumberLocation;
BULK INSERT Fixed From 'E:\code\DB\fixedbook-sort.txt' With
(FIELDTERMINATOR = ',', ROWTERMINATOR = '\n')
use NumberLocation;
BULK INSERT Fixed From 'E:\code\DB\fixedbook-sort.txt' With
(FIELDTERMINATOR = ',', ROWTERMINATOR = '\n')
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment
您的评论将使我blog更有动力~