> I set up cold fusion with an excel file but I can't seem to find any
> documentation on how to perform a query on the file. I have tried
> referencing it my the excel sheet name and by file name. Please Help
OK, here's how it would be used;
The ODBC source points to the file
The "table name" is the sheet name with a $ on the end, but always put
square brackets around it; [Sheet1$]
Row 1 MUST, I repeat, MUST be the column names
Once a column is decided upon (setting in the ODBC) for it's data type, it's
GOT to be that datatype, other types will be ignored (i.e. putting some text
in a column that starts as numeric will return a NULL)
Formatting for visual needs means nothing to ODBC, it's the actual data
which determines it's type - you must FORCE it to be text if you want text
On this point, unless you want to release the ODBC before you upload, then
use an Access database and Link Table to point to it, but the same ODBC
limitations apply
How to force a cell to be text;
You need a "copy" column beside it and put the following formula into it;
=Mid("'"&a2,2,Len(a2))
Assuming that A2 is the cell that contains the original data
Also, Sometimes you get blank rows at the bottom of the table, these DO
count as rows - so be very careful about this...
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.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
