Hey all ... quick question. I know this has been written about before, but I need a little more clarification.
I recently switched from a Cold Fusion 5 to MX. I had some functionality for uploading Excel files and reading them into the database. I was using the CFUSION_DISABLE_DBCONNECTIONS function to unlock my Excel files, but apparently that is no longer supported in MX.
Unlocking the file is a major problem as I use one file (and datasource) as a focal point that I continually overwrite with new info and re-run the process using the same datasource.
I have heard that you can unlock the Excel file with a bogus query but I was unable to get results with that. I also have a script that processes every error and forwards it to a "human readable" explanation page and emails me a copy of the error, so I was wondering if I could get Cold Fusion to skip passed the error and keep going on with the uploading and overwriting of the file in the rest of the Cold Fusion page.
Besdides all of that, I am now getting an error when I read the file with the following query:
<cfquery datasource="examExcel" name="getDataSheet">
It continually tells me that it cannot locate 'Sheet$' even though the datasource name is correct, and it does correctly point to the Excel file, which I know (after repeated checking) has a "Sheet1".
Any help regarding skipping past errors, unlocking Excel files, or the error listed above would be MOST APPRECIATED!