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:300842 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
