系统提供了EXCEL的ODBC驱动，可以用SQL实现，very easy! just like
select *** from *table where ...
while not eof(rs)
...
wendselect count(*) from *table where ...
select *** from *table where ...
while not eof(rs)
...
wendselect count(*) from *table where ...
调试欢乐多
我这段时间就在做这项工作呢，只是如果数据很大的话，速度就比较慢了。