Hi,

For a web project that I am working on I need to be able to read in an excel file using a DNS-less connection. Right now I am able to get this to work but only when the Excel file is closed. I need to be able to read the file even when someone has it open and is editing it. I know that this is possible when you use an access file and I was wondering if anyone knew a way to do it with an excel file. This is the error that I get when I try to run the page with the excel file open.

[Microsoft][ODBC Excel Driver] Can't open database '(unknown)'. It may not be a database that your application recognizes, or the file may be corrupt.

Thanks