Thanks Seamus, That's the exact thing I need! I just got it and tried it out and it took me all of 5 minutes to get it to work. I can see it's going to be exactly what I need. Programmable enough to be able to dynamically assign the correct tables to the various login ids and they'll be able to click a button in the admin module and get the correct table sent as a spreadsheet in seconds.
Thanks for the other suggestions too. I can see they're helpful, but in this case it's the Query2Excel tag that takes the statuette home tonight. Cheers, Mike Kear Windsor, NSW, Australia AFP WebWorks -----Original Message----- From: Seamus Campbell [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 5:39 PM To: CF-Talk Subject: Re: Exporting data to Excel spreadsheet Try CF_Query2Excel tag - works very well if you can't find it on Macromedia send me another email - I've got a copy here somewhere Seamus At 05:23 pm 3/04/02 , you wrote: >At one of my clients, the content providers each look after an allocated >part of the data used for displaying information on the web site. They >want to be able to export their data to a spreadsheet so they can review >it and update it off line. These are not IT people but experts in their >various consumer fields. They want me to put a button in their admin >areas for each category of comsumer data so it will export the data for >them automatically. I was going to do it this way and I wondered if there >was a better way: > > >(1) Have a spreadsheet already attached to CF as a datasource. >(2) Use a CFQuery to delete all the records in that datasource. >(3) CFQUERY the SQL7 table the content provider wants to export >(4) loop through the query, inserting the data into the (now blank) >spreadsheet. >(5) Use CFMail to email the spreadsheet to the user (getting their email >address from their logon details). > >I seem to remember a function or a tag that output the results of a query >into spreadsheet format but I can't find any reference to it any more. >Can anyone enlighten me? > > >Is this the easiest way? Will CFMail be able to send the spread sheet or >will I need to unlock it from the server first? in which case, how can i >do that automatically? > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
