I am trying to connect to an Excel document in my ASP.NET 1.1 app. I am using the following connection string:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1";

When I attempt to fill my dataset, it throws an error when the file is open. Is there a way to perform a read only connection where it doesn't matter if the file is open?

Thanks,
Mike