Excel bulkcopy insert

Sign in to answer this question.

• 

  Manoj Bhoir11y agoPosted Jun 2, 2015, 12:47 PM

  Hi Laxman,

   

  You can use Combobox or Dropdownlist to select Worksheet from Selected Excel.

  To get all Worksheet name in Combobox or dropdownlist please see this link :

  C# - Retrieve Excel Workbook Sheet Names. 

  After that based on selected Worksheet you can upload excel data into your database using SQLBulkCopy.

  Please check this link :

  Using SqlBulkCopy to import Excel SpreadSheet data into SQL Server in ASP.Net using C# and VB.Net 
• LS

  Laxman Sharma11y agoPosted Jun 2, 2015, 12:11 PM

  Rajesh pls help me out on this matter your help will be really appreciate
• LS

  Laxman Sharma11y agoPosted Jun 2, 2015, 7:33 AM

  I want to select Worksheet Name from the given Excel Sheet .When prompting to select the Excel data I can select the Inner worksheet .Pls suggest me Regards laxman
• 

  Rajeesh Menoth11y agoPosted Jun 2, 2015, 7:21 AM

  Hi,

   

  Check this : http://www.aspsnippets.com/Articles/Using-SqlBulkCopy-to-import-Excel-SpreadSheet-data-into-SQL-Server-in-ASPNet-using-C-and-VBNet.aspx