> Anyone know of a references for this?
OK, warnings I've given before (in Aidan's FAQ);
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
