基于VB的SQL-Server数据库与Word文档的数据交互

简要介绍了一套OA软件系统。该系统使用VisualBasic和ADO方法成功实现了在SQL-Server数据库和Word文档之间进行数据交互,具有对Word文档进行读写和对数据库中信息进行相关处理的功能。文章首先分析了该软件系统的应用背景、理论基础和总体设计架构方案,介绍了软件具有的功能及模块结构,然后根据文档信息的录入检测、信息读取、容错和报错机制、已读信息写入数据库等文档信息录入过程,以及查询、统计、导入、导出等已录入信息的处理流程分别阐述了软件编程的实现原理和方法,并给出了相应的主要程序代码,最后说明了该软件系统的实际应用效果。

Using the Visual Basic to Exchange Data between SQL Server Database and Documents of MS -Word

In this paper, a software system, in which the Visual Basic and ADO (Microsoft ActiveX Data Object) are applied to exchange data between SQL-Server database and documents of MS-Word, is introduced, and this system has the functions of reading/writing the documents of MS-Word and managing the information of the database. Above all, the background of application, theory foundation and the blue print in the mass are analyzed, the function and the module framework are presented. And then, according the course of input inspecting, information reading, error abiding/reporting and writing the recognized data into the database, and the process of the querying/computing the data, exporting/importing the information of the database, the elements and means of the software programming are expatiated on separately, furthermore, the correlative main program code of this software system are offered. Finally, the actual application effect of this system is explained.