I made the subject look easy so I can have more viewers ;) But here is my problem.. After having trouble with working cfx_Excel2Query ( I finally reverted to it in the end and got it working), I thought why not do this:
1) Create a odbc dsn to a excel file 2) Create a cf dsn to this odbc dsn 3) User uploads his file, I copy it as the file to which the dsn si specified. 4) I query the file using [sheet$1] as the table, and so on. This method works fine, however, sometimes (most of the times), it appears the file being used as the dsn gets 'locked'. I cann't delete, rename etc, 'next' upload of file fails to overwrite this file because it is locked. Basically this method is too inconsistent. My question is, is there anything I need to do to make sure the file is 'released' after the query has run? If this one thing is solved, I no longer have to use third party solutions, I can just create a dsn to the file and keep overwriting the file with the new file whenever. Any suggestions? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298884 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
