any ideas for file upload solution

Question

Hello everyone My problem is 1. I want to let end user to fill-in an Excel file which contains two columns file description and file location on client side; 2. I want to let end user to upload the Excel file to my web server then I want my web server to find the files specified in Excel file and upload them into web server. Any documents or samples for me to start with? thanks in advance George

George George · Answer

Thanks. I am still thinking about alternative solutions. Currently I am thinking of writing a client program to upload the files because the file may be several hundred M bytes. Do you think writing a client side program to upload file (but still using Http) is a good idea in my situation? regards George

John Penn · Answer

To get the file uploaded place a FileUpload control (one of the controls available in Visual Studio) on the desired page. In order to programmatically load and iterate through an Excel file you have 2 basic choices: 1) Install Excel on the web server and use the Excel Automation objects 2) Use a 3rd-party component (such as offered by Syncfusion )