I am currnetly using this connection string within an asp but if fails if someone already has the spreadsheet open.

ConnString="Provider=Microsoft.Jet.OLEDB.4.0;Mode=read;Data Source=" & FILENAME & "; Extended Properties=""Excel 8.0;HDR=NO;IMEX=1;"""



Is it possible to connect to an Excel spreadsheet even if it is open?


Thanks