原帖由 商人 于 2011-6-21 17:34 发表
谢谢蓝桥老师的帮忙,我的这个代码就是利用这个牛刀来生成的。
不过我的问题不是如何生成,而是如何解决用这个生成的代码来透视之后,数据源的数字都是数值形式的,但是在透视表里大多都变成了文本了(双击调取可 ...
没有发现这个现象,请把工作簿放到E盘根目录下试试看:
SELECT 序号,姓名,差旅费,业务招待费,0 as 办公费,0 as 培训费 FROM [1$] UNION ALL SELECT 序号,姓名,差旅费,业务招待费,0 as 办公费,0 as 培训费 FROM [10$] UNION ALL SELECT 序号,姓名,差旅费,业务招待费,0 as 办公费,0 as 培训费 FROM [11$] UNION ALL SELECT 序号,姓名,差旅费,业务招待费,0 as 办公费,0 as 培训费 FROM [12$] UNION ALL SELECT 序号,姓名,差旅费,业务招待费,办公费,0 as 培训费 FROM [2$] UNION ALL SELECT 序号,姓名,差旅费,0 as 业务招待费,0 as 办公费,培训费 FROM [3$] UNION ALL SELECT 序号,姓名,差旅费,0 as 业务招待费,0 as 办公费,0 as 培训费 FROM [4$] UNION ALL SELECT 序号,姓名,差旅费,业务招待费,0 as 办公费,0 as 培训费 FROM [5$] UNION ALL SELECT 序号,姓名,差旅费,业务招待费,0 as 办公费,0 as 培训费 FROM [6$] UNION ALL SELECT 序号,姓名,差旅费,业务招待费,0 as 办公费,0 as 培训费 FROM [7$] UNION ALL SELECT 序号,姓名,差旅费,业务招待费,0 as 办公费,0 as 培训费 FROM [8$] UNION ALL SELECT 序号,姓名,差旅费,业务招待费,0 as 办公费,0 as 培训费 FROM [9$]
1-12月合并透视.rar
(7.92 KB, 下载次数: 49)
|