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
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Mahesh ChandPosted Apr 4, 2006, 11:06 AM
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.