如何在不将Office安装到系统中的情况下将excel数据导入数据库 [英] how to imports excel data into database without installing the office in system

问题描述

我没有安装我的系统办公室.如何在.net应用程序中添加Microsoft Excel 10.0对象库.

我的资源是，我想使用简单的C#代码将excel数据导入到我的sql数据库中.请给我解决方案..

i my system office is not installed .how to add Microsoft Excel 10.0 Object Library in .net application .

my requarement is ,i want to imports excel data into the my sql data base with simple c# code .please give me solution ..

推荐答案

用于添加MS的引用将Office dll插入.net，您需要安装MS Office安装程序

用于将数据从excel导入到SQL的链接:-

http://support.microsoft.com/kb/321686 [ http ://blog.sqlauthority.com/2008/01/08/sql-server-2005-export-data-from-sql-server-2005-to-microsoft-excel-datasheet/ [ ^ ]

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926 [ ^ ]

http://geekswithblogs.net/nagendraprasad/archive/2009/03/26/export-sql-server-data-into-excel.aspx [

For adding a reference of MS Office dll into .net you need to install the MS Office setup

Links for importing the data from excel to SQL:-

http://support.microsoft.com/kb/321686[^]

http://blog.sqlauthority.com/2008/01/08/sql-server-2005-export-data-from-sql-server-2005-to-microsoft-excel-datasheet/[^]

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926[^]

http://geekswithblogs.net/nagendraprasad/archive/2009/03/26/export-sql-server-data-into-excel.aspx[^]

这篇关于如何在不将Office安装到系统中的情况下将excel数据导入数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！