I've used Excel datasources in the past, but simply reading data from them. Now, I'd like to be able to export data to an Excel spreadsheet. I'm not sure what the best approach to doing this might be. My biggest concerns are concurrency issues. I suspect I may run into problems dealing with OS-imposed file locks as well.
The first problem that I'm running into is: I have an Excel datasource that points to an Excel file. If that single file is to be used for the data output, then I need to clear the file each time before beginning the export process. The ODBC driver is saying that DELETE FROM is unsupported. Any advice appreciated, Jim ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
