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

date posted 15th September 2002 20:45

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]
> >
> >




_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com