Using .xls datasource
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. Thanks, Erika Foster engineering-environmental Management Applications Developer (505) 866-1654 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Using .xls datasource
Erika, Go to www.cfcomet.com it will have everything you need. Have fun We are doing a lot of CF/Excel at the moment Regards D Daryl Fullerton, Managing Partner, BizNet Solutions, Allaire Premier Partner (Ireland) 133 - 137 Lisburn Road Belfast BT9 7AG N.Ireland Direct +44 (0) 28 9022 7888 Tel +44 (0) 028 9022 3224 Fax +44 (0) 028 9022 3223 [EMAIL PROTECTED] Http://www.BizNet-Solutions.com [EMAIL PROTECTED] (Chairman) Http://www.cfug.ie The Irish Cold Fusion User Group -Original Message- From: Erika Foster [mailto:[EMAIL PROTECTED]] Sent: 08 January 2001 09:56 To: CF-Talk Subject: Using .xls datasource 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. Thanks, Erika Foster engineering-environmental Management Applications Developer (505) 866-1654 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Using .xls datasource
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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists