导出EXCEL的问题
我用下面的语句把数据导出excel:
insert into opendatasource('Microsoft.Jet.OLEDB.4.0',
'Data Source="d:\book1.xls";User ID=Admin;Password=;Extended properties=Excel 5.0;')...Sheet1$
select RoomNo,EmployeeId,EmployeeName,EmployeeCount,Division,PElecNum,ElecNum,ElecUse,PColdWaterNum,ColdWaterNum,ColdWaterUse,PHotWaterNum,HotWaterNum,HotWaterUse,PGasNum,GasNum,GasUse,FreeElec,FreeCWater,CAST(ElecMoneyCount AS NVARCHAR(10)),CAST(CWaterMoneyCount AS NVARCHAR(10)),CAST(HWaterMoneyCount AS NVARCHAR(10)),CAST(GasMoneyCount AS NVARCHAR(10)),CAST(AverElecMoney AS NVARCHAR(10)),CAST(AverCWaterMoney AS NVARCHAR(10)),CAST(AverHWaterMoney AS NVARCHAR(10)),CAST(AverGasMoney AS NVARCHAR(10)),CAST(AllMoney AS NVARCHAR(10)),CAST(CatvMoney AS NVARCHAR(10)),CAST(Rent AS NVARCHAR(10)),Remark
FROM #Result order by RoomNo
导出后打开excel是导出了,可是列的位置不对,比如RoomNo列本来是第一例的,可打开excel后RoomNo列的数据跑到最后1列,其他的列都乱了,
我的excel的列头的,只是列头的中文的,跟#Result表的字段名不一样,这个有关系吗???