Welcome to the new platform of Programmers Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use it's exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.
Here's my scenario:
1. Prompt user to load .xls file from their machine
2. On click event of Upload button, save the rows in the .xls file to an existing table on the database server
So, if the existing database table has 10 rows, and the user's .xls file has 10 rows, after the click event of the Upload button, the table will now have 20 rows.
I'm told since the db server is a separate machine, I have to map a drive to the server.
How can I do this w/in my ASP.NET application?