The invention discloses a method for importing change column data into a
database. The specific implementation process is as follows: firstly, recognizing a column attribute of a
data source, and setting corresponding rules and
data conversion rules of a
data source column and a
database column in a classification way; performing data importing, importing a change column into the
database, determining which column of the database that the data are stored according to a column
correspondence rule, and determining values of data storage according to the
data conversion rules; and finally, when storing, the data are read and saved by blocks, meanwhile, recording error information, and prompting once after saving, thereby facilitating users to correct multiple errors at a time. Compared with the prior art, the method for importing the change column data into the database provided by the invention uses the setting method to convert data of an Excel and other data sources into a database
system, which effectively saves the
workload and working time of
data entry personnel, and rapidly and effectively imports complex data into a business
system; and besides, the practicability is strong, the scope of application is wide, and the method has a very good popularization and application value.