摘要
为了提高信息管理系统中数据导入导出操作的灵活性和通用性,本文详细介绍了在Visual Studio 2008使用C#语言、通过引用Office的COM组件技术,结合Microsoft SQL Server 2005实现了Excel数据导入到数据库以及数据库数据导出到Excel的设计思路和实现方法。实践证明该方法有较强的通用性和实用性。
In order to improve the flexibility and popularity of data import and export in information management system, this paper introduces the ideas and the ways of implementation of Excel data importing to database and database data expor- ting to Excel, which combined with Microsoft SQL Server 2005 in Visual Studio 2008, uses C# programme, and applies COM components technology of Office. The operation practices show that the method is widely useful and available.
出处
《智能计算机与应用》
2014年第5期83-85,共3页
Intelligent Computer and Applications
关键词
C#
COM组件
导入导出
C#
COM Components
Excel
Import and Export