(SQL应用) 利用数据透视表对工作簿及工作表名称分级透视,做上年同期对比(附讲解)

bibisin

谢谢LZ分享

pcxangle

感谢楼主的分享

xgy0214dxy

谢了，看懂了

KOLAOBAN

kjkljkljlkjl

函数菜鸟

下载学习！谢谢分享！

美人计

SELECT "2006" AS 年度,"上海" AS 地区,"1月" AS 月份,* FROM[C:\Documents and Settings\gzzz\桌面\Test\2006\上海.XLS`.`1月$] UNION ALL SELECT "2006" AS 年度,"上海" AS 地区,"2月" AS 月份,* FROM[C:\Documents and Settings\gzzz\桌面\Test\2006\上海.XLS`.`2月$] UNION ALL SELECT "2006" AS 年度,"上海" AS 地区,"3月" AS 月份,* FROM[C:\Documents and Settings\gzzz\桌面\Test\2006\上海.XLS`.`3月$] UNION ALL SELECT "2006" AS 年度,"温州" AS 地区,"1月" AS 月份,* FROM[C:\Documents and Settings\gzzz\桌面\Test\2006\温州.XLS`.`1月$] UNION ALL SELECT "2006" AS 年度,"温州" AS 地区,"2月" AS 月份,* FROM[C:\Documents and Settings\gzzz\桌面\Test\2006\温州.XLS`.`2月$] UNION ALL SELECT "2006" AS 年度,"温州" AS 地区,"3月" AS 月份,* FROM[C:\Documents and Settings\gzzz\桌面\Test\2006\温州.XLS`.`3月$] UNION ALL SELECT "2007" AS 年度,"上海" AS 地区,"1月" AS 月份,* FROM[C:\Documents and Settings\gzzz\桌面\Test\2007\上海.XLS`.`1月$] UNION ALL SELECT "2007" AS 年度,"上海" AS 地区,"2月" AS 月份,* FROM[C:\Documents and Settings\gzzz\桌面\Test\2007\上海.XLS`.`2月$] UNION ALL SELECT "2007" AS 年度,"上海" AS 地区,"3月" AS 月份,* FROM[C:\Documents and Settings\gzzz\桌面\Test\2007\上海.XLS`.`3月$] UNION ALL SELECT "2007" AS 年度,"温州" AS 地区,"1月" AS 月份,* FROM[C:\Documents and Settings\gzzz\桌面\Test\2007\温州.XLS`.`1月$] UNION ALL SELECT "2007" AS 年度,"温州" AS 地区,"2月" AS 月份,* FROM[C:\Documents and Settings\gzzz\桌面\Test\2007\温州.XLS`.`2月$] UNION ALL SELECT "2007" AS 年度,"温州" AS 地区,"3月" AS 月份,* FROM[C:\Documents and Settings\gzzz\桌面\Test\2007\温州.XLS`.`3月$];

jadyjjk

非常感谢

jadyjjk

通过对楼主的帖子的应用，发现以下问题，
透视表：透视多个工作簿，SQL 使用多重查询，透视表添加计算字段后，列字段不能并列显示，

帖子地址如下，烦请帮帮忙
http://club.excelhome.net/viewth ... &extra=page%3D1

pdamen

留个记号，日后学习

fenglin19861010

如有更多月份，或者是更多的地方，如何在代码中体现，需要如何编写？请讲解