Excel bulkcopy insert

Laxman Sharma

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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manoj Bhoir11y ago
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
0
Laxman Sharma11y ago
Rajesh pls help me out on this matter your help will be really appreciate
0
Laxman Sharma11y ago
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
0
Rajeesh Menoth11y ago
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
0