如何将txt文档插入sql2000数据库
方法一:
建立存储过程
BULK INSERT Northwind.dbo.[Order Details]
FROM 'temp.txt'
WITH
(
FIELDTERMINATOR = '|',
ROWTERMINATOR = '\n',
FIRSTROW = 2
)
FIELDTERMINATOR 字段分隔符
ROWTERMINATOR 记录分隔符
建立存储过程
BULK INSERT Northwind.dbo.[Order Details]
FROM 'temp.txt'
WITH
(
FIELDTERMINATOR = '|',
ROWTERMINATOR = '\n',
FIRSTROW = 2
)
FIELDTERMINATOR 字段分隔符
ROWTERMINATOR 记录分隔符