Not sure if this has been suggested. Just generate an html table as the excel results, change the content type to excel (similar to streaming an image through a page) and they'll be prompted to download the results (or it'll open in excel if they've set the associations correctly)
Jeff On Fri, 3 Sep 2004 05:54:28 +0100 (BST), mohan kumar <[EMAIL PROTECTED]> wrote: > i See ur problem > pls try this : - http://www.asp101.com/samples/xl.asp > > click the above link for ur problem it may be useful > > best regard > S.K.Mohan Kumar EMail -ID :- [EMAIL PROTECTED] > > Phillip C Goff <[EMAIL PROTECTED]> wrote: > Try this then: It's a freeware component called "ASP Report Wizard". > It can supposedly save generated reports out as an Excel file. > > Blurb: Quickly transform almost any data into powerful, dynamic > content. Tightly integrate reporting functionality into your ASP web > applications. Empower end users with the flexibility to sort, filter and > preview reports before printing and exporting (excel, xml, csv etc...). > > Here's the URL. > http://www.aspwebsolution.com/ > > Phillip > > Phillip Goff > Programmer Analyst III, Information Systems > Information Technology > University of Louisville > MITC 109 Cubicle E-7 > 502-852-6263 (at HSC from 7/01/03 - 9/30/04) > 502-386-4798 (Cell) > > >>> [EMAIL PROTECTED] 9/2/2004 3:15:25 PM >>> > Thanks Phil, > > That is what I am doing now. The customer does not want to have to deal > with > that and wants files he can open directly. > > Joel > > -----Original Message----- > From: Phillip C Goff [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 02, 2004 1:49 PM > To: [EMAIL PROTECTED] > Subject: Re: [AspClassicAnyQuestionIsOk] Create Excel File > > Joel, > > One method that I have employed to create files that Excel can open is > to > dynamically generate a flat txt file that is either comma-delimited or > tab-delimited. You can use the FileSystemObject to generate this txt > file. > As you cycle through your result recordset, just append a new line to > the > txt file. When your file has finally been completely generated, then > dyanmically provide a hyperlink to it. When your client clicks the > link, > he/she should save the file to their local hard drive. Then they > should > launch Excel and open the new file. Excel will display a message > saying > that the file appears to be delimited, and will ask how it is > delimited. > Once this is answered, then the file will open up in Excel. > > Hope this gives you some ideas at least, > > Phillip > > Phillip Goff > Programmer Analyst III, Information Systems > Information Technology > University of Louisville > MITC 109 Cubicle E-7 > 502-852-6263 (at HSC from 7/01/03 - 9/30/04) > 502-386-4798 (Cell) > > >>> [EMAIL PROTECTED] 9/2/2004 2:39:52 PM >>> > I have created an ASP application which collects data and stores it in > an > Access database on the server and generates reports that are viewable > on a > web site. My customer would like to have the same data in Excel format. > Is > it possible to automatically create Excel files from data on the server > so > that they could click on a link or a button and get a file to download. > If > so, where can I go to learn how to do this? > > Thanks in advance - Joel > > Yahoo! Groups Links > > Yahoo! Groups Links > > Yahoo! Groups Links > > > Yahoo! Groups SponsorADVERTISEMENT > > --------------------------------- > Yahoo! Groups Links > > To visit your group on the web, go to: > http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ > > To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. > > Yahoo! India Matrimony: Find your life partneronline. > > [Non-text portions of this message have been removed] > > > > > > Yahoo! Groups Links > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
