this has already been posted. here it is again:
----------------------
i have a client who does this all the time. the tool i built works like
this:
1) They upload an Excel file for which a DSN *already exists*
2) I read the Excel file and populate SQL with the content
3) I use CFUSION_DISABLE_CONNECTIONS([DSN],1) to force CF to release the
lock on the Excel file
4) I use CFUSION_DISABLE_CONNECTIONS([DSN],0) to re-enable the Excel file
DSN for query
5) I use 3 & 4 so the client can immediately upload another version of the
same file immediately if they want to.
* The CFUSION_DISABLE_CONNECTIONS command only works in CF 4.5.x.
If you don't use 3 & 4, CF will put a lock on the Excel file for a while
(like 30 min or so; never really bothered to figure out the exact amount of
time).
--Dylan
-----Original Message-----
From: Mike Townend [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 19, 2001 2:44 AM
To: CF-Talk
Subject: RE: Excel Questions
You could try looking at http://www.cfcomet.com
they have all sorts of information about using CF with COM and Office
Applications
-----Original Message-----
From: Chris Martin [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 18, 2001 7:16
To: CF-Talk
Subject: Excel Questions
Hey everyone.
I was wondering, what exactly is involved in using CF to query from, update,
insert, edit, et cetera an Excel file?
I want to try writing a custom tag or something similar that can work with
excel files. It would be more as a learning experience for me then anything
else.
Can anyone suggest some resources or pointers?
Thanks,
Chris Martin
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
