excel or access:
exec master..xp_cmdshell 'bcp "select * from syscolumns" queryout "c:\1.xls" -c -T'html:
exec sp_makewebtask 'c:\1.htm','select * from syscolumns'
exec master..xp_cmdshell 'bcp "select * from syscolumns" queryout "c:\1.xls" -c -T'html:
exec sp_makewebtask 'c:\1.htm','select * from syscolumns'
exec master..xp_cmdshell 'bcp "select * from syscolumns" queryout "c:\1.mdb" -c -T'
在导出 html 时 ,出现很多在信息,可以去除这些信息,只保留字段和数据吗