Batch Update with Excel files

Task to do:

Preparing for working out Batch update over excel for the SMD website. The website does not have uploading functions before, the current one only support for downloading or generating reports for download.

-Do not use ADO COM object as possible in this updates. (complicates things and difficult to maintain)
-In uploading the excel files to the server, the excel file names have to be modified in order to avoid overwriting of files for different users, the file names can be append with systemtime (and username) to have an understanding of the file and also prevent the overwriting exposure.
-When updating the database, do it record by record: (i.e. Read a record from the excel, and then carry out the corresponding update in the database instead of read the whole excel file and save all the record in the runtime program, and then carryout all the updates together in the database) One of the cons is to save some memory space of the runtime program during execution.


Functions Completed:
-ASP Pages for uploading and saving the files into the server