基于VBA和COM组件进行数据转换在文廷式数据库信息采集中的研究与应用

Research and Application of Data Conversion Based on VBA and COM Components in Information Collection of Wen Tingshi Database

关系型数据库支持从外部数据文件批量导入数据到内部数据表,但数据文件须满足关系型数据库的格式化要求,以.DOC或者.DOCX存储的数据无法直接导入到关系型数据库。本文以萍乡学院文廷式数据库信息采集为例,通过VBA和COM组件技术,实现将DOC类格式的文本数据和图像转换为纯文本形式存储表格数据的.CSV文件,使得包括MSSQL Server在内的关系型数据库能够快速准确地获取大批量外部数据,为字处理数据格式转换为格式化数据提供了一种新的解决方法。

Relational databases support the import of data in batch from external data files to tables, but files must meet the formatting requirements, and word-generated storage with DOC or DOCX data can not be imported directly into databases. In the paper, a new solution is presented for converting word processing data formats into formatted data in Pingxiang University Wentingshi database＇s information collection. By means of VBA and COM component technology, it enables conversion of the DOC text data and images into CSV files stored in the form of plain texts. Therefore, relational databases like MSSQL Server are able to get access to large amounts of external data quickly and accurately.