save data from excel sheet in sql server database

[viktor9990]

I want to save data from an excel sheet into sql server database dynamically with asp.net. I wonder how to do that? Any exampel code would be helpful. Thanks

[minhpc_bk]

Hi there, ADO.NET can treat an Excel file as a data store, you can use ADO.NET to query data from the .xls file, then insert into SQL. You can see this KB: http://support.microsoft.com/kb/306572/[^]