for upload and insert excel file data into database.

Question

i am upload excel file with multiple record ..and when click save button how to insert this data in to database for it related column....

Khargesh Rajput · Answer

http://www.aspsnippets.com/Articles/How-to-Import-Excel-Sheet-data-into-SQL-Server-using-ASPNet.aspx

Testdemo Foremail · Answer

this is not working. because i m using store procedure..and insert data into database.

Khargesh Rajput · Answer

http://www.aspsnippets.com/Articles/Using-SqlBulkCopy-to-import-Excel-SpreadSheet-data-into-SQL-Server-in-ASPNet-using-C-and-VBNet.aspx