本帖最后由 wuxiang_123 于 2011-1-12 11:09 编辑
太多工作表,填充0太麻烦,修改SQL就可以了,在OLE DB编辑框中加上;IMEX=1.在输入以下SQL语句,具体看操作动画
select 业务员,客户单位,月份,月初余额+0 as 月初余额,本月销售+0 as 本月销售,本月回款+0 as 本月回款,月末余额+0 as 月末余额,本月超期余款+0 as 本月超期余款 from
(select "一月" as 月份,* from [1月$] union all select "二月",* from [2月$] union all select "三月",* from [3月$] union all select "四月",* from [4月$] union all select "五月",* from [5月$] union all select "六月",* from [6月$] union all select "七月",* from [7月$] union all select "八月",* from [8月$] union all select "九月",* from [9月$] union all select "十月",* from [10月$] union all select "十一月",* from [11月$] union all select "十二月",* from [12月$])