ADO技术在Microsoft Office Excel中的应用

摘要

介绍说明了ADO技术在Microsoft Office Excel中的应用,以数据库SQL Server2000为例,进行了查询数据、增加数据、删除数据、更新数据的操作。%This paper introduced and analyzed the application of the technique ADO in Microsoft Office Excel, and illustrated the processes of search, input, deletion and update of data with the example of SQL Server 2000 database.