【摘要】 依据表中数据的特点,Excel表可以分为匀质和非匀质两种类型,而关系数据库表只有匀质一种类型,所以非匀质的Excel表数据不能直接导入到关系数据库表中,需要进行表结构的匀质化转换。为了解决这一问题,提出了两种非匀质EXCEL表转换成关系数据库表的方法,实现了非匀质Excel表结构向关系数据库表结构的转换,并用C#编程实现了Excel表数据向关系数据库表的自动导入。更多还原

【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.更多还原