Topic awaiting preservation: Upload Multiple Preset Files (Page 1 of 1)

I need to have a user upload multiple files (around 10) from one of 22 directories via a simple interface and then trigger a stored procedure to trigger a DTS package to import the new data. It's for a bowling site where the leagues need to be updated whenever their scores have been entered, so it can't be scheduled.

I know how to do the last part, it's the uploading I'm have trouble with because the form FILE type doesn't allow to specify the file location beforehand. (IIS, ASP, SQL server)

The poster has demanded we remove all his contributions, less he takes legal action.
We have done so.
Now Tyberius Prime expects him to start complaining that we removed his 'free speech' since this message will replace all of his posts, past and future.
Don't follow his example - seek real life help first.

true, i realized that.

i was thinking some active x control or something that prompts the user to say hey, this site is trying to copy your files, and let's them click OK would do it, if it exists.

The poster has demanded we remove all his contributions, less he takes legal action.
We have done so.
Now Tyberius Prime expects him to start complaining that we removed his 'free speech' since this message will replace all of his posts, past and future.
Don't follow his example - seek real life help first.

thanks, one of those site had a nice way to do it in VBA using CreateObject("InternetExplorer.Application")