Hi Pete This did come up, but its all about ease of use for the people who are going to be using the spreasheet (non techies).
If worse comes to worse I'll fall back on that option Many Thanks Mark -----Original Message----- From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED] Sent: 17 February 2005 15:41 To: CF-Talk Subject: Re: Excel Lock Issue Probably less elegant than you are looking for, and certainly not an answer to your problem, but having the users upload a .csv file and then using cffile to read the contents to a variable and then loop through that to insert into SQL Server might also work. Pete On Thu, 17 Feb 2005 15:24:19 -0000, Mark Smyth <[EMAIL PROTECTED]> wrote: > Hi Chaps could use some advice here. Coldfusion 6.1. > > The scenario is a user uploads an excel spreadsheet which then needs > to be imported into SQL Server. > > I've set up an ODBC connection to the uploaded spreadsheet (it'll be > the same name, same location every time) and then a odbc socket in the > administrator as per: > http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_18656 > > Now this all works fine, but its maintaining the lock on the > spreadsheet after the page has finished processing, which will make > it impossible to upload a new one. The only way I have found a way > round it so far is to restart the ODBC server service (or cfmx > service), which is not really workable. > > I've tried everything I though might work, for example: > run a query against a non existant query/datasource to try and relase > the lock (like the old access lock workaround) ran a query against > another spreadsheet via a different odbc socket to try to release the > query. > Tried the purgeQueryCache() and ["disable"] methods of the datasource > factory. > > But no luck, its still maintaining the lock > > any ideas? > > thanks > mark > > Mark Smyth > > Certified Advanced ColdFusion MX Developer > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195180 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
