| 摘 要: 依据表中数据的特点,Excel表可以分为匀质和非匀质两种类型,而关系数据库表只有匀质一种类型,所 以非匀质的Excel表数据不能直接导入到关系数据库表中,需要进行表结构的匀质化转换。为了解决这一问题,提出了 两种非匀质EXCEL表转换成关系数据库表的方法,实现了非匀质Excel表结构向关系数据库表结构的转换,并用C#编 程实现了Excel表数据向关系数据库表的自动导入。 |
| 关键词: 匀质Excel;非匀质Excel;关系数据库 |
|
中图分类号: TP311
文献标识码: A
|
|
| Two Methods of Transforming Inhomogeneous Excel Table into Relational Database Table |
|
FANG Muyun, ZHAO Changxian, ZHANG Zhumeng
|
(School of Computer Science and Technology, Anhui University of Technology, Ma 'anshan 243002, China )
fangmy@ahut.edu.cn; 1826939647@qq.com; 2602617221@qq.com
|
| Abstract: According to the characteristics of the data in the table, the Excel table can be divided into homogeneous and inhomogeneous types, while the relational database table has only one type, so the inhomogeneous Excel table data cannot be directly imported into the relational database table, and it is required to implement the homogenization transformation of the table structure. In order to solve this problem, the paper proposes two methods of transforming inhomogeneous Excel table into relational database table. The study achieve the transformation from inhomogeneous Excel table structure to relational database table structure, and the automatic import of Excel table data into relational database table in C# programming language. |
| Keywords: homogeneous excel; inhomogeneous excel; relational database |
