INSERT INTO OPENDATASOURCE ('MICROSOFT.JET.OLEDB.4.0','Text;DATABASE=d:\outfile')...[data#txt] SELECT top 10 flowno,cardno FROM bil_flowlist INSERT INTO OPENDATASOURCE('MICROSOFT.JET.OLEDB.4.0','Excel 5.0;DATABASE=d:\outfile\book1.xls' )...[Sheet1$] SELECT top 10 flowno,cardno FROM bil_flowlist谢谢大家的回复!!!!!
Exec master..xp_cmdshell
'bcp "select * from test.dbo.ta" Queryout "D:\TEST.txt" -c -q -S "." -U "sa" -P "wuxi"', NO_output
sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO
sp_configure 'xp_cmdshell', 1
GO
RECONFIGURE
GOExec master..xp_cmdshell
'bcp "select * from test.dbo.ta" Queryout "D:\TEST.txt" -c -q -S "." -U "sa" -P "wuxi"', NO_outputsp_configure 'show advanced options', 0
GO
RECONFIGURE
GO
-- 导出文本文件
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'
INSERT INTO OPENDATASOURCE(MICROSOFT.JET.OLEDB.4.0,Text;DATABASE=c:\)...[data#txt] SELECT * FROM text1
'bcp "select * from test.dbo.ta" Queryout "D:\TEST.txt" -c -q -S "." -U "sa" -P "wuxi"', NO_output
SELECT top 10 flowno,cardno FROM bil_flowlist
INSERT INTO OPENDATASOURCE('MICROSOFT.JET.OLEDB.4.0','Excel 5.0;DATABASE=d:\outfile\book1.xls' )...[Sheet1$]
SELECT top 10 flowno,cardno FROM bil_flowlist谢谢大家的回复!!!!!