Hi ALL, Actually i have a Standard version or Format of Excel sheet. i want to upload this Excel sheet in SQL Server through my Web application.i searched(googling) many application but didn't get solution as er my requirement SO pls guide me..
AS per i think..pls refer attached .JPEG file. i) Suppose there is three Field in my Excel sheet. Firstly i upload this excel sheet. ii)After upload right sides Drop down will be populate that Three Field (Column).which is in my excel sheet iii) user can map these field..corresponding to left side drop down which is comes from sql DB iv) Then finally upload to SQL.. CAN IT POSSIBLE >> ?? Becoz i seen these all functionality in an application.and that application upload 10000 rows within 2 Minute. i'll wait for reply
