Thank you, Chris. I need to download all of the tables regardless the order of columns since the order of columns are not important. In that case, I will not need to hard-code the column names as to there are a ton of column names. Do you know of solutions for this?
Thx much On Jan 2, 2008 9:46 AM, Christopher Vigliotti <[EMAIL PROTECTED]> wrote: > this may be helpful to you >> > http://www.bennadel.com/blog/474-ColdFusion-Component-Wrapper-For-POI-To-Read-And-Write-Excel-Files.htm > > - Christopher Vigliotti > Sr ColdFusion Developer > Goldbelt Raven > > > On 1/2/08, Tech Gate <[EMAIL PROTECTED]> wrote: > > > > I have a dozen of tables in the sql 2000 db, and need to extract ALL > > rows of the tables with ALL column names into one Excel file (with a > > dozen of Worksheets) through cf page so that users can download the > > entire db as needed. > > > > thx much > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295706 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4