ADO技术在Microsoft Office Excel二次开发中的应用

The application of ADO technique in the further development of Microsoft Office Excel

介绍ADO技术在Microsoft Office Excel二次开发中的应用,以烟台职业学院教学质量管理系统中的管理软件Excel为例,对数据库SQL Server2000进行查询、删除以及批量更新.目前,该系统已成功应用,为学校提供了快捷、准确的信息,进一步提高了信息化管理水平.

This paper introduces and demonstrates the application of ADO technique in the further develop- ment of Microsoft Office Excel and illustrated the process of search, deletion and updating in SQL Server 2000 with the example of the management software Excel in the teaching quality management system in our college. So far, this system has been successfully operated, which provided quick and accurate information and improved the level of information management in our college.