Abstract: Aiming at data exchange between unstructured information Word data table of information systems and Relational Database(RDB), this paper proposes an interoperability method of Word data table based on PIA and ADO.NET techniques. This method solves the data conversion problems between Word table and RDB by operating Word table through Word PIA object and adopting strategies such as data extraction, data standardization inspection, virtual table definition, sub-paragraph injection and table customization. It realizes volume data importing implemented from Word table data to database and data exporting supported from database to Word data table. The feasibility and practicality of the method is verified through application cases.

Key words: unstructured information, PIA technique, ADO.NET technique, Word data table, data conversion

摘要： 针对信息系统中非结构化信息Word数据表与关系数据库之间的数据交互，提出一种基于PIA和ADO.NET技术的Word数据表互操作方法。该方法通过Word PIA对象操作Word表格，采用数据提取、数据规范化检查、虚拟表定义、分段导入和表格定制等策略解决关系数据库与Word表格之间的数据转换问题，将Word表格数据批量导入数据库，导出数据库数据生成Word数据表。通过应用案例验证该方法的可行性和实用性。

关键词: 非结构化信息, PIA技术, ADO.NET技术, Word数据表, 数据转换

CLC Number: 

• TP311.12