I'll give that a try and see what happens.
-Original Message-
From: Gerald Guido [mailto:[EMAIL PROTECTED]
Sent: Monday, March 10, 2008 9:09 AM
To: CF-Talk
Subject: Re: OT: SQL Server Accessing Excel file.
Is there any way you can copy the file and use the copy? That was my
first
thought.
On Mon, Mar 10, 2008 at 8:29 AM, DURETTE, STEVEN J (ATTASIAIT)
[EMAIL PROTECTED] wrote:
Hi all,
Sorry for the off topic, but this has been a real pain in my behind.
We
have a process were our SQL server reads in data from an Excel file.
From there the data is used in various CF pages.
The problem is that the file that we import data from is opened by
users
to make changes before the next data load. A few of them, when it's
their turn to edit the file, open the file and leave it open and leave
for the day.
They are are internal customer and threats of corporate policy
violation, going to their bosses, etc have no effect. No matter if
they
have the file open or not, if the data doesn't load, it's considered
our
fault.
Does anyone know of anyway to force SQL Server 2000 to open an excel
file in read only mode? That way I can get the data and not have to
worry anymore.
I googled it, but I didn't find much, except how to track down who has
the file open. (Which doesn't help me).
Thanks,
Steve
Steve Durette
SR IT Analyst
586-466-7654
[EMAIL PROTECTED]
~|
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:300855
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
