基于VC#的Excel表格与SQL Server数据库的批量数据导入导出技术研究

Research of batch data import and export technology from Excel table to SQL server database based on VC#

在信息管理系统实际应用中,批量数据导入导出技术是提高数据录入速度和方便用户将数据库信息以多种报表方式予以输出的有效途径。文章详细介绍基于VC#开发平台实现Excel表格与SQLServer数据库之间批量数据导入导出技术的流程、步骤和实现方法。

In the practical application of the information management system, the batch data import and export technology is the effective way which enhances the data input speed and outputs the database information by many kinds of report form way. It＇s very convenient for the users. Based on VC# development platform,this paper introduces the flows,the steps and the ways of implementation of batch data import and export technology from Excel table to SQL Server database.