Bulk Import Update Delete from Excel to Sql using asp.net

Question

Hi I am very new to this site. I have a web application for MIS management. I want to learn how to import bulk data from an excel sheet to sql table through web. Browse option preferred on a web page i design. Once the data imported to sql table later if i want to update few data into table just modify the data in excel sheet and again submit for updating. Same for Deleting and downloading data from sql to excel. If any one can help me step by step and the easy way i would be very thankful to you. John. Delhi

Sibi Babu · Answer

Hi Mohit Thank you for your quick reply. But could you please give me a sample code? So that i can make accordingly.

Mohit Vijay · Answer

You can use open SQL query. You need to provide xml path in open Query of sQL and execute it with C# code.

Bulk Import, Update, Delete from Excel to Sql using asp.net