Copy data from an Excel file into a SQL table
I am working on a web page which would do the following:
User clicks an "upload" button.
When button is clicked the following needs to happen:
1) Verify that the file exists
2) Copy the file to a designated location
3) Run a SQL 2000 DTS package to copy the excel file in to a SQL table
4) Delete the copy of the file at the designated location.
5) Validate that each step was properly executed.
6) Display either an error message or a successful message.
Please include any sample code if possible.