摘要
导入Excel表数据是大多数信息系统中具有的重要功能,固定导入Excel指定表中的数据实现简单,但用户操作时受限较多,由此设计的导入模块通用性较差。本文介绍的将Excel文件任意表、任意字段导入进数据库表的通用导入模块的设计方法,能有效地解决固定导入数据方法中存在的问题,适用范围较广。
Data can be imported to Excel is the important function for most of Information system. The implement of data being im- ported to appointed form in Excel regularly is very simple. But there are a lot of limitations when users operating it, which would cause the discrepancy in popularity of the importing module.This paper has introduced methods of general guiding module how to im- port any form and any filed from Excel to the database, which would resolve problems which exist in ways of importing data regular- ly, have a large scope in applicability.
出处
《微计算机信息》
2011年第2期240-242,共3页
Control & Automation
