> Is there a reason for not just using the Excel spreadsheet as the
> datasource? I do this on one of my sites and it works great.
OK, one big reason;
Once ODBC gets hold of an Excel spreadsheet as a datasource, it won't let go
of it, so if you need to replace it then you have to Stop/Start the server
to be able to upload/download it...
It's a lot easier to make a Link table and let Access handle the source
Another reason to not use Excel as a read datasource is that it decides what
type of column the data is by reading the top rows, then that whole column
MUST be that type - if it decides it's numeric, then text entries are
ignored (and the other way around)
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
