关于导入数据时的问题

summer1601

各位前辈，

      今天在做合并多个表来做数据透视表时，提示“  08P1不是一个有效名称，请确认它不含无效的字符和标点，且名称不太长”。

      名字改了几次也不见效，不知为什么？ 请指点啊。例子见附件，谢谢啦，在线等

     SQL：select "08P1", * FROM [D:\TP大表\08P1`.`08P1$] UNION ALL select "08P2", * FROM [D:\TP大表\08P2`.`08P2$] UNION ALL select "08P3", * FROM [D:\TP大表\08P3`.`08P3$] UNION ALL select "08P4", * FROM [D:\TP大表\08P4`.`08P4$] UNION ALL select "08P5", * FROM [D:\TP大表\08P5`.`08P5$] UNION ALL select "08P6", * FROM [D:\TP大表\08P6`.`08P6$] UNION ALL select "08P7", * FROM [D:\TP大表\08P7`.`08P7$] UNION ALL select "08P8", * FROM [D:\TP大表\08P8`.`08P8$] UNION ALL select "08P9", * FROM [D:\TP大表\08P9`.`08P9$] UNION ALL select "08P10", * FROM [D:\TP大表\08P10`.`08P10$] UNION ALL select "08P11", * FROM [D:\TP大表\08P11`.`08P11$] UNION ALL select "08P12", * FROM [D:\TP大表\08P12`.`08P12$] UNION ALL select "08P13", * FROM [D:\TP大表\08P13`.`08P13$] UNION ALL select "09P1", * FROM [D:\TP大表\09P1`.`09P1$] UNION ALL select "09P2", * FROM [D:\TP大表\09P2`.`09P2$] UNION ALL select "09P3", * FROM [D:\TP大表\09P3`.`09P3$] UNION ALL select "09P4", * FROM [D:\TP大表\09P4`.`09P4$]

[ 本帖最后由 summer1601 于 2009-6-22 11:52 编辑 ]

小蚁雄兵

改成[D:\TP大表\08P1].[08P1$]试试看