Re: FN-FORUM Require help in ASP 3.0...

date posted 15th September 2002 22:48

Danish,

Do you have FTP access to the server where the Excel file resides ?

Dennis

----- Original Message -----
From: "Danish Umer" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Sunday, September 15, 2002 8:40 PM
Subject: FN-FORUM Require help in ASP 3.0...


> Thanks for your help Dennis but problem is that the excel file is on
another
> server & I wanna automatically donwload this excel file to my server then
> convert it without open it to comma separated file.
>
> Regards
> Danish Umer
>
> >From: "Dennis McDermott" [EMAIL REMOVED]
> >Reply-To: [EMAIL REMOVED]
> >To: [EMAIL REMOVED]
> >Subject: Re: FN-FORUM Require help in ASP 3.0...
> >Date: Sat, 14 Sep 2002 17:17:09 +0100
> >
> >I am not sure if you are having a problem downloading the file or
creating
> >the comma delimited text file, if it's the later you could try this.
> >
> >Connect to the Excel file
> >Create a recordset
> >Loop through the recordset building each comma delimited line as you go
> >(ensure the data does not contain any commas, use the replace function
> >first)
> >Output each comma delimited line using the filesystem object
> >
> >I believe you will also need to set the disposition header if you want to
> >raise a file download dialog box (see here)
> >http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q260519
> >
> >Dennis
> >
> >Website: http://www.dennismcdermott.co.uk
> >All outgoing mail is scanned with Symantec's Norton Anti-Virus software
> >
> >
> >----- Original Message -----
> >From: "Danish Umer" [EMAIL REMOVED]
> >To: [EMAIL REMOVED]
> >Sent: Saturday, September 14, 2002 1:54 PM
> >Subject: FN-FORUM Require help in ASP 3.0...
> >
> >
> > > Hi,
> > > I wanna access or download an excel file & convert it to comma
separated
> > > text file without open the excel file. I m trying this from 2 weeks
but
> >I
> > > even didn't get idea to perform this task. Please help me to
accomplish
> >it.
> > >
> > > Regards
> > > Danish Umer
> > >
> > > _________________________________________________________________
> > > MSN Photos is the easiest way to share and print your photos:
> > > http://photos.msn.com/support/worldwide.aspx
> > >
> > >
> > > ============================================================
> > > = Advanced web hosting solutions from Saffas. =
> > > = Unix, PHP, mySQL, SSL, Perl, Control Panel, 24/7 access. =
> > > = Why pay more for less? http://www.saffas.com =
> > > ============================================================
> > >
> > > Sponsor the forum for as little as £1 at:
> > >
> > > http://www.freelancers.net/cgi/sponsor.cgi?action=show
> > >
> > >
> > > Advertise with Freelancers.net +Additions+
> > >
> > > http://www.freelancers.net/advert.php
> > >
> > >
> > > Freelancers and Freelance Jobs:
> > > http://www.freelancers.net
> > >
> > > Forum FAQs:
> > > http://freelancers.netrickery.com
> > >
> > > To unsubscribe please email:
> > > [EMAIL REMOVED]
> > >
> > > If you have difficulties unsubscribing please email:
> > > [EMAIL REMOVED]
> > >
> > >
>
>
>
>
> _________________________________________________________________
> MSN Photos is the easiest way to share and print your photos:
> http://photos.msn.com/support/worldwide.aspx
>
>
> ============================================================
> = Advanced web hosting solutions from Saffas. =
> = Unix, PHP, mySQL, SSL, Perl, Control Panel, 24/7 access. =
> = Why pay more for less? http://www.saffas.com =
> ============================================================
>
> Sponsor the forum for as little as £1 at:
>
> http://www.freelancers.net/cgi/sponsor.cgi?action=show
>
>
> Advertise with Freelancers.net +Additions+
>
> http://www.freelancers.net/advert.php
>
>
> Freelancers and Freelance Jobs:
> http://www.freelancers.net
>
> Forum FAQs:
> http://freelancers.netrickery.com
>
> To unsubscribe please email:
> [EMAIL REMOVED]
>
> If you have difficulties unsubscribing please email:
> [EMAIL REMOVED]
>
>