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
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Manish Kumar ChoudharyPosted Jan 8, 2015, 11:06 PM
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