BCP从sql server 导出 excel

 exec master..xp_cmdshell 'bcp "select top 1 * from Northwind..Customers" queryout c:\Temp.xls -c -q -S "tom" -U sa -P'

用法:  bcp {dbtable | query} {in | out | queryout | format} datafile
  [-m maxerrors]            [-f formatfile]          [-e errfile]
  [-F firstrow]             [-L lastrow]             [-b batchsize]
  [-n native type]          [-c character type]      [-w wide character type]
  [-N keep non-text native] [-V file format version] [-q quoted identifier]
  [-C code page specifier]  [-t field terminator]    [-r row terminator]
  [-i inputfile]            [-o outfile]             [-a packetsize]
  [-S server name]          [-U username]            [-P password]
  [-T trusted connection]   [-v version]             [-R regional enable]
  [-k keep null values]     [-E keep identity values]
  [-h "load hints"]
NULL
+++++++++++++++++++++++++++++++++++++++++++

Excel文件已经存在,而且已经按照要接收的数据创建好表头——追加记录

insert into OPENROWSET('Microsoft.Jet.OLEDB.4.0','Excel 5.0;HDR=YES;DATABASE=c:\temp2.xls',temp$) 
select * from Northwind..customers