使用下面的脚本

Use below script

DECLARE @PATH VARCHAR(500)
DECLARE @Name Varchar(500)
DECLARE @SQL VARCHAR(500)

SET @Name = TableData.xls'

SET @PATH = '\\C:\'

SET @SQL = 'SELECT * FROM TableName'

DECLARE @cmd VARCHAR(800)
SET @Cmd = 'mkdir ' +@PATH
EXEC master..xp_cmdshell @cmd

DECLARE @FILENAME VARCHAR(200)
SET @FILENAME = @PATH + @Name

EXEC sp_makewebtask
  @outputfile = @FILENAME,
  @query = @SQL,
  @nrowsperpage = 40000,
  @lastupdated=0 ,
  @resultstitle = '  '