You might want to look at a COM solution (try cfcomet for examples, though it doesn't look like it's been updated for a while) for converting .XLS files to .CSV files on the server, without user interaction.
Pete On Thu, 17 Feb 2005 15:46:58 -0000, Mark Smyth <[EMAIL PROTECTED]> wrote: > 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:195197 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
