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?