Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Export in CF

Author  Topic 

figgy
Starting Member

1 Post

Posted - 2002-02-13 : 10:00:52
Hi!

I am exporting a report to XLS file. The file can be created and is saved in the server. My problem now is save the file to another server, say at www.mysite.com/reports/report1.xls

Is this possible? I am getting an error when I do this...

Thanks.

MichaelP
Jedi Yak

2489 Posts

Posted - 2002-02-13 : 10:35:38
You usually can't do something like that due to IIS permissions. If you could hackers etc would fill webserver HDD's just because they could.

What you'l need to do to send the XLS file to the other server is come up with some "recieving" program / tool on the other server and "send" your XLS file to it. Two good things to research are
1. Setting up an FTP server on the destiation box, and FTP the file there.
2. Do a search on 4guysfromrolla.com, 15seconds.com, or learnasp.com about ASP file uploading. You could build something that allows you to "POST" your XLS file to a webpage, and that webpage reads the XLS File and puts it in the right place on the destination PC. Not super easy, but I can tell you from experience this technique works well.

Go to Top of Page
   

- Advertisement -