I need to provide a function in an Access 2000 db that will take a textfile (queryresults in a specialized format) and upload/transfer it to a remote server over the internet. Never used windsock so not sure if its the right tool for the function but I think redirecting a command window's FTP session would work.

So which method sounds best and easiest for the function?

Thanks