EXCEL利用编辑OLE DB查询创建动态原材料收发存汇总表 跪求方法

ㄗs¨胖辉

看过 《 利用编辑OLE DB查询创建动态原材料收发存汇总表_ExcelHome》以后把自己的账目也想实现自动计算结存
附：教程http://v.youku.com/v_show/id_XODIzOTk2NTY=.html
但是每次都不成功

出现这个信息

求各位帮我瞅瞅是哪里的问题

这是我的帐 2020店1月.zip (69.03 KB, 下载次数: 67)

2012-1-25 23:14 上传

点击文件名下载附件

利用的 函数语句
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 [调出$]

zez

估计是表中有太多的假空单元存在。我测试楼主的SQL语句，显示的是列数不匹配。改为：
SELECT "期初库存",* FROM [期初库存$a:n] UNION ALL SELECT "采购",* FROM [采购$a:n] UNION ALL SELECT "返厅",* FROM [返厅$a:n] UNION ALL SELECT "销售",* FROM [销售$a:n] UNION ALL SELECT "退货",* FROM [退货$a:n] UNION ALL SELECT "调入",* FROM [调入$a:n] UNION ALL SELECT "调出",* FROM [调出$a:n]
又出现太多的空行，导致行数超过65536行。
所以只能改为：
SELECT * FROM(SELECT "期初库存",* FROM [期初库存$a:n] UNION ALL SELECT "采购",* FROM [采购$a:n] UNION ALL SELECT "返厅",* FROM [返厅$a:n] UNION ALL SELECT "销售",* FROM [销售$a:n] UNION ALL SELECT "退货",* FROM [退货$a:n] UNION ALL SELECT "调入",* FROM [调入$a:n] UNION ALL SELECT "调出",* FROM [调出$a:n]) WHERE [销售日期：：] LIKE '%'