> Can someone point me in the right direction to find information
> on using an
> Excel file as a CF datasource? I've got a highly formatted Excel
> spreadsheet that my client would like to be able to
> add/update/delete lines
> through his browser.
OK, a few of quick pointers;
Table names are strange to call - [$tableName] (or maybe the other way
round)
Column names MUST be supplied
Columns types are decided at the opening of the table - thus if Excel
decides that it's a Text field, then all numeric types are ignored (and the
other way round)
Once ODBC gets hold of an Excel sheet, it won't let go - CF needs to be
stopped and started to release the file
I would suggest running it via an Access Link table, it means you can
down/up load the file as you require
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
