22,206
社区成员
发帖
与我相关
我的任务
分享
03S000 20091221070136 169240030702 0757
03S000 20091221070145 C1408843 0757
03S000 20091221070149 C0762613 0757
03S000 20091221070158 168296896600 0757
03S000 20091221070202 168299948482 0757
03S000 20091221070226 C0762614 0757
03S000 20091221070233 168301951510 0757
03S000 20091221070240 C0736182 0757
03S000 20091221070247 169166494781 0757
03S000 20091221070252 168302725533 0757
create table #tablename(a varchar(20),b varchar(50),c varchar(20),d varchar(50))
BULK INSERT #tablename
FROM 'D:\test.txt'
with
( --check_constraints
--DATAFILETYPE='char'--(包含unicode字符)如果包含字符和非unicode字符,就
--datafiletype='widenative'
--,MAXERRORS=0
FIELDTERMINATOR=' '
,ROWTERMINATOR='\n'
)
select * from #tablename
drop table #tablename
/** 导入文本文件
EXEC master..xp_cmdshell 'bcp dbname..tablename in c:\DT.txt -c -Sservername -Usa -Ppassword'
/** 导出文本文件
EXEC master..xp_cmdshell 'bcp dbname..tablename out c:\DT.txt -c -Sservername -Usa -Ppassword'
或
EXEC master..xp_cmdshell 'bcp "Select * from dbname..tablename" queryout c:\DT.txt -c -Sservername -Usa -Ppassword'
导出到TXT文本,用逗号分开
exec master..xp_cmdshell 'bcp "库名..表名" out "d:\tt.txt" -c -t ,-U sa -P password'
BULK INSERT 库名..表名
FROM 'c:\test.txt'
WITH (
FIELDTERMINATOR = ';',
ROWTERMINATOR = '\n'
)
BULK INSERT Northwind.dbo.[Order Details]
FROM 'D:\test.txt'
WITH
(
FIELDTERMINATOR = ' ',
ROWTERMINATOR = '|\n'
)