reading in an excel file->.net web application

[Guest]

Hi just wondering if anyone has tried to read in an excel file into a web
application?
I have a web app that I want to be able to update records in an mssql
database and use an excel file for data input.
Thanks.

 

[Steve C. Orr [MVP, MCSD]]

You can use Excel as an ADO.NET data source:
http://www.dotnetspider.com/technology/kbpages/1080.aspx

Here are some other articles that may help as well:
http://SteveOrr.net/articles/ExcelExport.aspx
http://SteveOrr.net/articles/ExportPanel.aspx
http://SteveOrr.net/reviews/AsposeExcel.aspx
http://SteveOrr.net/reviews/OfficeWriter.aspx

 

[Guest]

ok thanks this is what I was looking for.
--
Paul G
Software engineer.

You can use Excel as an ADO.NET data source:
http://www.dotnetspider.com/technology/kbpages/1080.aspx

Here are some other articles that may help as well:
http://SteveOrr.net/articles/ExcelExport.aspx
http://SteveOrr.net/articles/ExportPanel.aspx
http://SteveOrr.net/reviews/AsposeExcel.aspx
http://SteveOrr.net/reviews/OfficeWriter.aspx