Extracting all tables into one Exel file

[gatetec]

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.

pls let me know.

thx much

 

[FALCONSEYE]

<cfcontent type="application/x-msexcel">Org ID stuff1 stuff2 stuff3
<cfoutput query="queryName">#org_id# #stuff1# #stuff2# #stuff3#
</cfoutput>

Also, you can define tab and new line feeds like chr() and create something like
<cfoutput query="queryName">#org_id##tab##stuff1##tab# #stuff2##tab##stuff3##newLine#
</cfoutput>

hope it helps...

http://www.jetansolutions.com