| 两种非匀质Excel表转换成关系数据库表的方法 |
| |
| 作者姓名： | 方木云 赵长鲜 张祝梦 |
| |
| 作者单位： | 安徽工业大学计算机科学与技术学院 |
| |
| 基金项目： | 安徽省高校自然科学研究重大项目"基于互联网+ERP建设离散制造业智慧工厂"(KJ2018ZD007). |
| |
| 摘 要： | 依据表中数据的特点,Excel表可以分为匀质和非匀质两种类型,而关系数据库表只有匀质一种类型,所以非匀质的Excel表数据不能直接导入到关系数据库表中,需要进行表结构的匀质化转换。为了解决这一问题,提出了两种非匀质EXCEL表转换成关系数据库表的方法,实现了非匀质Excel表结构向关系数据库表结构的转换,并用C#编程实现了Excel表数据向关系数据库表的自动导入。
|
| 关 键 词： | 匀质Excel 非匀质Excel 关系数据库 |
Two Methods of Transforming Inhomogeneous Excel Table into Relational Database Table |
| |
| Authors: | FANG Muyun ZHAO Changxian ZHANG Zhumeng |
| |
| Affiliation: | (School of Computer Science and Technology,Anhui University of Technology,M^anshan 243002,China) |
| |
| 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 |
| 本文献已被 维普 等数据库收录！ |
|
