现代电子技术Issue(12)：71-73,3.
Excel数据导入数据库的设计实现
Design of database to import data from Excel
王旭辉1
作者信息
- 1. 厦门大学 电子工程系，福建 厦门 361005
- 折叠
摘要
Abstract
The basic principle and implementation method to import Excel sheets into database are analyzed in detail. It im⁃proved the efficiency of data processing,reduced the burden of engineering technicians and eliminate the mistakes in data pro⁃cessing. The advanced developmental tool of VS 2010 .NET is adopted to select import files dynamically and create the middle⁃ware Dataset for import data. The corresponding relation of data fields and Excel sheets in database is used to automatically read⁃in the data outside the database and store it unitedly. This method has generality so that it could be used in various aspects.关键词
Excel电子表格/数据库/中间件/数据库连接Key words
Excel sheet/database/middleware Dataset/database connection分类
信息技术与安全科学引用本文复制引用
王旭辉..Excel数据导入数据库的设计实现[J].现代电子技术,2013,(12):71-73,3.
