Dim sqlstr As String sqlstr = "EXEC master..xp_cmdshell 'bcp" & """ kf_datain """ & " in " & """d:\输入.txt""" & " -c -t, -S" & """ wsserver""" & " -U" & """sa""" & " -P"" '"没有执行?为什么?
调试欢乐多
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'檢查看看你的參考對了沒有﹖
我执行的没有结果~可是我在SQL中调试中通过啊!~
我想问问上面的引号还是那个地方有错误????_______________________________________________________________________
源码:
Private sub Inputdata() Dim sqlstr As String sqlstr = "EXEC master..xp_cmdshell 'bcp" & """ kf_datain """ & " in " & """d:\输入.txt""" & " -c -t, -S" & """ wsserver""" & " -U" & """sa""" & " -P"" '"End sub