从Mssql导出数据到excel表中

insert into OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:/Reporttemplate/PPVAPO.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...[Sheet1$]
([Item No],[Item Description],[Item English Description],[StockingType],[Supplier ID],[Supplier Name],[IDCO],[IDCO Group],[IDCO Sub Group],[Receive Qty],[UOM],[Reason Code],[Average Price Last year],[Average Price This Year],[Variance],[Var Amount],[Remark])
SELECT ItemNo,ItemDescription,ItemEnglishDescription,StockingType,SupplierID,SupplierName,IDCO1,IDCO2,IDCO,ReceiveQty,UOM,case when Variance<>0 then  ReasonCode else '' end,AveragePriceLastyear,AveragePrice,Variance,VarAmount,'' as Remark
FROM PPTREPORTAPO WHERE PPTDATE=@CurDate AND WarehouseIDJDE=@WarehouseIDJDE and ReportType=@ReportType1
order by ItemNo