浅谈Excel中使用ADO对象访问数据库

Usage of ADO object to access database in Excel

数据库技术在处理大量数据,进行规范存储时具有很大优势,但其操作技术复杂,而Excel在日常工作中应用广泛,并且在分析数据、绘制图表等方面简单易用。微软最新的ADO技术,将Excel和数据库接合起来,综合了它们的优点。文中以人事数据查询为例,通过ExcelADO对象来访问数据库,并且通过VBA代码自动化处理相关数据,生成表格。

Database technology has a great advantage of dealing with large amounts of data, and organizing those storages, but its complexity limits the usage. Microsoft Excel was widely used in our daily work, and has a great advantage in analyzing data and drawing diagrams, etc. The latest Microsoft ADO technology combines Excel and database with both advantages. This paper uses personnel database query as an example, writing VBA code to access database through Excel ADO object, and automatic generating a data sheet of query results.