I generate comma delimited files (.csv) from a database a lot and whenever I link to the files on the web server, they open in Excel when I click on them.
Bob Filipiak A question not asked is a lost opportunity to learn. ----- Original Message ----- From: "Joel Elias" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 02, 2004 3:15 PM Subject: RE: [AspClassicAnyQuestionIsOk] Create Excel File > 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 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/
