RE: Best method for Export to Excel...

2008-08-18 Thread Jaime Metcher
+1 to POI. jXLS is also nice if you need templating. But +2 to SSIS (or similar). CF as a data pump just does not scale. Jaime > -Original Message- > From: Dawson, Michael [mailto:[EMAIL PROTECTED] > Sent: Tuesday, 19 August 2008 1:56 AM > To: CF-Talk > Subject: RE:

RE: Best method for Export to Excel...

2008-08-18 Thread Dawson, Michael
With 20,000 records, do you actually need to create it on-demand for each user? Can you have a scheduled task rebuild the .xls file every so often? If that would work, then you could just have SSIS dump the .xls file on your web server. This would take CF completely out of the process. m!ke --

Re: Best method for Export to Excel...

2008-08-18 Thread Alan Rother
IMHO: Ben Nadel's POI utility: http://www.bennadel.com/projects/poi-utility.htm Is the best choice, it has saved me a hundred times. =] -- Alan Rother Adobe Certified Advanced ColdFusion MX 7 Developer Manager, Phoenix Cold Fusion User Group, AZCFUG.org ~~