Find each table columns count while upload the excel file

Question

I have One Excel sheet that excel sheet have three different table and different columns i want find each table columns count while upload the excel file using asp.net with c#. please as soon has possible Thanks&Regs Manavalan.A

Manish Kumar Choudhary · Answer

Hi magesh manavalan  it's possible just you need to implement your logic Go through following links it will help you http://www.aspsnippets.com/Articles/How-to-Import-Excel-Sheet-data-into-SQL-Server-using-ASPNet.aspx http://stackoverflow.com/questions/24281255/how-do-you-import-excel-data-to-sql-server-using-asp-net-c-sharp-where-the-table