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