Cheers, Found a custom tag (Query2Excel) that does exactly what I wanted. Nick
-----Original Message----- From: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]] Sent: 01 November 2001 11:55 To: CF-Talk Subject: RE: Help - SQL to Excel > Can somebody show me some code to simply query a databse then by > clicking a link export recordset to Excel and open worksheet displaying > data. > I have looked at CFCOmet but cannot get example working. Change the Content Type to be Excel and then lay it out in a table I'm trying to find the exact instruction, but as soon as I do, I'll post it (unless someone has beaten me to it) Philip Arnold Director Certified ColdFusion Developer ASP Multimedia Limited T: +44 (0)20 8680 1133 "Websites for the real world" ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. ********************************************************************** ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm 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
