how i want to apload excel file to database in asp.net mvc

Moniroaf Shaker

10y894.NET

hi guys

i want to read or upload excel file table to database by asp.net mvc then we can show all the records in that excel file on my page

after that we going to sql server managment program write some query to execute in that excel file

then we can show the result of the query on my page and save the result in my file excel (like new filed for it we add)

the last step download this excel file from database with new field (query result) .

this idea is small part from big project

if any one has idea or code that he can help me

i pleasure to help each other

thanks to all

3 Replies

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

Delpin Susai Raj10y ago
http://techbrij.com/read-excel-xls-xlsx-asp-net-mvc-upload
0
Moniroaf Shaker10y ago
thanks
0
Vinay Singh10y ago
check the link
http://www.codeproject.com/Tips/752981/Import-Data-from-Excel-File-to-Database-Table-in-A
http://www.mikesdotnetting.com/article/297/the-best-way-to-import-data-from-excel-to-sql-server-via-asp-net
http://social.technet.microsoft.com/wiki/contents/articles/31790.asp-net-mvc-upload-read-excel-file.aspx
0