I'm currently looking for properties for a connection string that can be used to connect to an Excel file in readonly mode. A Google search gives me many examples of connection strings, but I cannot find a specification of all the features in the "Advanced Properties" section of the OleDb connection string.
At the moment I have this:
Provider = Microsoft.Jet.OLEDB.4.0; Data Source = D:\Data\Customers.xls; Extended Properties = 'Excel 8.0; Mode=Read; ReadOnly=true; HDR=Yes';
However ... I made this up with examples. So the questions are: 1. What is a decent source for OleDb Connection String documentation / link? 2. Is the connection string above really a connection to an Excel file in readonly mode?
Thanks!
source share