OT: SQL Server Accessing Excel file.

2008-03-10 Thread DURETTE, STEVEN J (ATTASIAIT)
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

Re: OT: SQL Server Accessing Excel file.

2008-03-10 Thread Gerald Guido
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

RE: OT: SQL Server Accessing Excel file.

2008-03-10 Thread DURETTE, STEVEN J (ATTASIAIT)
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