Export/Import via web

Scenario:
- W2k server sp4 / sql server 2k sp4 box.
- firewall with only port 80 opened.
I have to:
Query data from remote server to export into local server.
I would like to do it via ASP/IIS in one step.
How can I do it?
Regards.
Gibe si fatto passare perch Rossi dietro come una purga, prima o
poi una cagata te la fa fare...!Hi
I am not an ASP expert and you may get a better reply in a internet
programming newsgroup.
I don't know of any way to do this in one step! Some componenets will let
you save the contents to file (such as an excel spreadsheet) but it is a two
stage process to select/insert the data and then save it. Other two process
would be to have scheduled jobs or DTS packages to create the files and then
allow the user to download them.
John
"Fabri" wrote:

> Scenario:
>
> - W2k server sp4 / sql server 2k sp4 box.
> - firewall with only port 80 opened.
>
> I have to:
> Query data from remote server to export into local server.
> I would like to do it via ASP/IIS in one step.
> How can I do it?
> Regards.
> --
> Gibe si è fatto passare perchè Rossi dietro è come una purga, prima o
> poi una cagata te la fa fare...!
>