Urgent: Export data from Excel into Sql server 2000

Question

Hello To Everybody I want to upload excel sheet data into sql server 2000 using asp.net and C#. Could anyone provide me C# code to do it ASAP? Thanks Ajay

Mahesh Chand · Answer

There are two steps to this process: 1. Read data from Excel sheets and store in a DataSet/DataTable 2. Connect to SQL Server and update database with the data (save it to the database). Now to learn how to read data from an Excel sheet into your application (DataSet/DataTable) go to Office Interoperability section and see articles by Mike Gold. To learn how to connect to the database and save data to the database go to ADO.NET section and see database updation related articles. Hope it helps.