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.