摘要
EXCEL对批量数据的多次重复或相似的统计和交叉性集合运算操作比较困难或效率不高，而使用Visual Basic开发平台利用ADO数据库连接和操作技术可以很好的解决这样的问题，提高EXCEL文件数据的处理效率。这个方法前提利用SQL语言的高度灵活的SELECT语句．以实现EXCEL单个或多个数据表数据的快速统计汇总、组合计算等，支持分组和排序。同时考虑到数据的输出．则使用了EXCEL的VBA技术的QueryTable对象实现ADO记录集数据向EXCEL文件的快速导入。
It is hard for EXCEL itself to repeat the same or similar job for many times in statistical or＇crossed data operation, however, the composed technology of Visual Basic, ADO, SQL and VBA has been found to be a good way to solve this problem, and it can improve the efficiency of EXCEL data to be dealt with. The precondition of the method is that the flexible SELECT statement in SQL which can realize rapid summarization, composed calculation of the data from one or multisheets with support for grouping and sorting. As to be concerned with the data output, the QueryTable object in VBA is use to import the RecordSet data into EXCEL frle efficiently.
作者
戴德宝
DAI De-bao （Business School, Shanghai University, Shanghai 200444, China）
出处
《电脑知识与技术》
2009年第4期2539-2540,2543,共3页
Computer Knowledge and Technology
关键词
EXCEL
SQL
VBA
VISUAL
Basic
ADO
EXCEL
Structured Query Language
Microsoft Visual Basic for Application
Visual Basic
Microsoft ActiveX Data Objects
