论文部分内容阅读
针对Web方式数据查询存在的局限性,从满足单位数据业务需求出发,开展了有针对性的研究,以广泛普及的Excel为客户端平台,基于ADO技术运用VBA对Excel功能进行二次开发,编制出灵活的数据查询系列模版,以满足各类数据查询需要;该模版分发部署简便,从数据库客户端安装到客户端数据源配置以及环境变量设置基本实现自动化;给数据查询应用人员带来极大便利,大幅提高数据查询、统计、处理的工作效率。
According to the limitations of data query in web mode, this paper has carried out targeted research to meet the needs of business unit data. Based on the popular Excel client platform, the secondary development of Excel function based on ADO technology was implemented. A series of flexible data query templates to meet the needs of various types of data query; the template distribution and deployment is simple, from the database client to client data source configuration and configuration of the basic realization of environmental variables automation; data query application personnel greatly Convenience, substantially improve data query, statistics, processing efficiency.