1
Answer

Copy data from an Excel file into a SQL table

David Mayer

David Mayer

17y
2k
1
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.
Answers (1)