Here is another trick that might help.
If you don't have access to the CF Administrator, you could try uploadoing
the spreadsheet with a different name, eg new_Excel.xls, then rename the old
one to old_Excel.xls, and rename the new one to the same name as the
Datasource.
I use this to update my large Access DB. I do this through an FTP client
rather that a file upload form, since my DB is pretty big.
HTH
paddy
----- Original Message -----
From: Brook Davies <[EMAIL PROTECTED]>
To: Fusebox <[EMAIL PROTECTED]>
Sent: Monday, December 18, 2000 1:00 AM
Subject: Re: OT: excel uploading
> Try, unchecking "maintain database connections" and also try running a
> query which generates an ODBC error just before you upload the new
> spreadsheet. This will generally unlock your DB. If you wrap it in a
> CFTry/Catch statement you could run the bad query and upload the new file
> from a single template...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
