Excel文件数据的SQL Server导入及其处理

Importing and Processing Date from Excel File into SQL Server

数据库导入程序及规则化处理方法,针对Excel文件导入SQL Sever数据库因格式转换出错丢弃数据提出。该程序用VB设计,在SQL Server中建立nchar临时数据表,将Excel保存为Unicode字符文本,调用导入导出向导时自动生成结构化存储文件包,运行时调用该文件包将文本文件自动导入SQL Server 数据库并对数据规则化处理。

The method of database file importing and data regularization was brought out, aiming at the data losing when data from Excel files was import into SQL Server database for the conversion failure of the data type. This program was compiled with VB, and temporarily nchar type table was created in SQL Server, and Excel files were saved as Unicode files. In running the program the data was imported into SQL Server database by calling the DTS package file generated by the DTS import/export wizard and then process the imported data.