从Excel读取数据并将数据存储到Sql Server数据库中 [英] Read the Data from Excel and stored data into Sql server Database

问题描述

朋友们...

我的客户招募..

他们给了Excel工作表.我们需要从excel表中读取数据，这些字段是制造商，零件号，描述和价格.我需要帮助来从Excel工作表中读取数据，并根据制造商和零件号将其存储到sqlserver数据库中.

请任何人给出执行的想法并解决该逻辑...

Hi Friends...

My client recruitment..

They given Excel sheet. We need to read the data from excel sheet, fields are manufacturer, partnumber, description, and price. I need help to read the data from Excel sheet and stored into sqlserver database based on the manufacturer and partnumber.

please any one give idea for do and solve that logic...

推荐答案

您可以引用以下链接

http://vb.net-informations.com/excel-2007/vb.net_excel_oledb.htm [^ ]

http://www.dotnetspider.com/forum/ViewForum.aspx?ForumId=28885 [ ^ ]

http://www.dotnetcurry.com/ShowArticle.aspx?ID=138 [ ^ ]

You can refer following links

http://vb.net-informations.com/excel-2007/vb.net_excel_oledb.htm[^]

http://www.dotnetspider.com/forum/ViewForum.aspx?ForumId=28885[^]

http://www.dotnetcurry.com/ShowArticle.aspx?ID=138[^]

请参见此处 [

这篇关于从Excel读取数据并将数据存储到Sql Server数据库中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！