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
