|
现在有11张worsheet位于同一个Workbook,每张Worksheet都是的35列 .我尝试用SELECT命令把11张表在新建Worksheet "Collection"里合并为一张数据透视表。
表名称如下
我输入的命令如下:
SELECT "Windy" AS POC,* FROM [Windy$] UNION ALL
SELECT "Joyce" AS POC,* FROM [Joyce$] UNION ALL
SELECT "Jessie" AS POC,* FROM [Jessie$] UNION ALL
SELECT "Elaine" AS POC,* FROM [Elaine$] UNION ALL
SELECT "Shiwen" AS POC,* FROM [Shiwen$] UNION ALL
SELECT "Kakis" AS POC,* FROM [Kakis$] UNION ALL
SELECT "Robinson" AS POC,* FROM [Robinson$] UNION ALL
SELECT "Kimi" AS POC,* FROM [Kimi$] UNION ALL
SELECT "HELEN" AS POC,* FROM [HELEN$]UNION ALL
SELECT "Julia" AS POC,* FROM [Julia$] UNION ALL
SELECT "Scarlett" AS POC,* FROM [Scarlett$]
结果总是显示“查询无法运行或数据库无法打开”
本人刚开始做数据相关的工作,十分生疏,找了许久不知道问题何在
各位大侠走过路过搭把手~帮帮忙看看吧。。。拜谢了~
azreal0000 发表于 2013-6-24 21:40
多谢了。。我最后仔细检查了所有别人发过来的源数据,发现有一张表的第36列第一行有一个空格。。。。我为 ...
不错,加油。
我有次帮人做这个题也是,最好发现也是数据的问题。
|
|