import excel to asp.net

Some time we got stuck in some situation in which we have to import large amount of data into the database but it can be cumbersome task if it is entered from a web form. This type of problem can be solved by importing excel data into MS-SQL Sever database. Let me explain the thing one by one