I need to "upload" data to my db in SQL. The data is on Excel files and the app is on the intranet, programmed in ASP.
I need the user to upload the excel file to the server... and then, the server must process the file in order to validate data in it and, if it is correct, server must insert the info to my SQL DB.
I know how to generate an Excel file to appear opened in browser to the user... but that is not what I need. The user already has the file, I only need the server to process the file with my algorithm to validate and extract the info to my DB.
Any help will be highly appreciated.