insert 表
select * from
OPENROWSET('MICROSOFT.JET.OLEDB.4.0'
,'Text;HDR=NO;DATABASE=C:\' --c:\是目录
,aa#txt) --aa#txt是文本文件名aa.txt
select * from
OPENROWSET('MICROSOFT.JET.OLEDB.4.0'
,'Text;HDR=NO;DATABASE=C:\' --c:\是目录
,aa#txt) --aa#txt是文本文件名aa.txt
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'
http://www.csdn.net/Develop/read_article.asp?id=22674
http://www.csdn.net/Develop/read_article.asp?id=22674
FROM 'c:\test.txt' --从c:\test.txt导入
WITH(FIELDTERMINATOR = '\t' --文本文件中,字段之间用tab做分隔符
)