Ok. So here is the problem. I have a web page, made in ASP.NET and C#, that allows a user to upload either an excel file or a csv file. Once they hit the validate button on the web page, the file is then read, information in the file is stored into a SQL Server 2005 database, where it is then further looked at and the results after the validation process is posted to another web page. I have done all of this, with no issues, with a csv. My issue is with the excel file. I need to know how to open it, I know how to use the connection string and OleDbAdapter, but only when you specify where the actual file is on your computer. I don't know how to get the file from the FileUpload control. The next problem is getting the specific data out of the excel file, and then saving it to the database. Can anyone help me with this. I have asked other places but they all tell me I should use a third-party program, which I can't, or it can't be done.

Thank you for any help.

I have read your issue. But I don't know how to solve it. But I heard a component uses C# to operate Excel. I think it may help you. More information:
http://www.e-iceblue.com/Knowledgebase/Spire.XLS.html

Thanks. What I need to do is take an excel file, find the range for certain cells in that file and save the data in those cells to a SQL Server database table. All done with ASP.NET 4.0, Visual Studio 2010, and C#.

When I read your introduction in details, I find that the component Spire.XLS can match your requirment. If you buy it, I will design a demo to you. If you have interest or question, you can send email to me. My email address is: tom.lu@e-iceblue.com