Excel bulkcopy insert

Question

Hi All I have created an application for the excel sheet bulk copy upload in SQl Server .My question is that while selecting Excel sheet How can I see all the worksheet name before uploading .Mean I want to see all the worksheet name before uploading so that I can select any of them Currentely I can select only sheet1 name. Please suggest me with with code example . Regards Laxman

Manoj Bhoir · Answer

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

Laxman Sharma · Answer

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

Laxman Sharma · Answer

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 Menoth · Answer

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