Excel bulkcopy insert

Jun 2 2015 7:15 AM

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.