请帮忙看一下我的语句错在哪里

东东8111

我有个工作薄，其中有12个表，想用SQL语名连接，将数据透视在一张表中，其中语句是：select "一月",* from [一月$] union all select "二月",* from [二月$] union all select "三月",* from [三月$] union all select "四月",* from [四月$] union all select "五月",* from [五月$] union all select "六月",* from [六月$] union all select "七月",* from [七月$] union all select "八月",* from [八月$] union all select "九月",* from [九月$] union all select "十月",* from [十月$] union all select "十一月",* from [十一月$] union all select "十二月",* from [十二月$]  
总是透视不成功，请帮忙看一下我错在哪里了？

mn860429

http://club.excelhome.net/viewthread.php?tid=407437

linpansheng

1. select "一月" as 月份, [一月$].*  from [一月$]
   
2. union all
   
3. select "二月" as 月份, [二月$].*  from [二月$]
   
4. union all
   
5. select "三月" as 月份, [三月$].*  from [三月$]
   
6. union all
   
7. select "四月" as 月份, [四月$].*  from [四月$]
   
8. union all
   
9. select "五月" as 月份, [五月$].*  from [五月$]
   
10. union all
    
11. select "六月" as 月份, [六月$].*  from [六月$]
    
12. union all
    
13. select "七月" as 月份, [七月$].*  from [七月$]
    
14. union all
    
15. select "八月" as 月份, [八月$].*  from [八月$]
    
16. union all
    
17. select "九月" as 月份, [九月$].*  from [九月$]
    
18. union all
    
19. select "十月" as 月份, [十月$].*  from [十月$]
    
20. union all
    
21. select "十一月" as 月份, [十一月$].*  from [十一月$]
    
22. union all
    
23. select "十二月" as 月份, [十二月$].*  from [十二月$]

复制代码

具体请看这个帖子：

SQL-多工作簿汇总 http://www.exceltip.net/thread-1686-1-1-232.html