Does anyone have tips on accessing excel files with cold fusion through
odbc. (other than 'don't'). With the following code I only get access to
one row of the spreadsheet (F2, F3, ...) Any suggestions?
<CFQUERY NAME="tmp" DATASOURCE="BorIMport">
SELECT G9
FROM "Form 3$"
</CFQUERY>
<CFLOOP LIST="#tmp.ColumnList#" INDEX="item">
<CFOUTPUT>#item# -- #Evaluate("tmp.#item#")#<BR></CFOUTPUT>
</CFLOOP>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
