David Mayer

David Mayer

  • NA
  • 4
  • 0

Copy data from an Excel file into a SQL table

Mar 22 2007 12:32 PM
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)