文本内容如下:
03033003509269|冯国萍 |20080329 | 20080630| 2015817| 2000000|
03033003135989|戴晓峰 |20080401 | 20080413| 500000| 500000| 我用EXEC master..xp_cmdshell 'bcp dbname..tablename in c:\DT.txt -c -t "|" -Sservername -Usa -Ppassword'
却一直显示出错
03033003509269|冯国萍 |20080329 | 20080630| 2015817| 2000000|
03033003135989|戴晓峰 |20080401 | 20080413| 500000| 500000| 我用EXEC master..xp_cmdshell 'bcp dbname..tablename in c:\DT.txt -c -t "|" -Sservername -Usa -Ppassword'
却一直显示出错
--生成臨時表再分拆
select * from OpenRowset('MSDASQL', 'Driver={Microsoft Text Driver (*.txt; *.csv)};
DefaultDir=E:\;','select * from roy.txt')
FROM OPENROWSET(BULK 'c:\temp\shippers.txt',single_ulob) AS S;