>I'm trying to get the connection string right. If I use:
>
>

>string sExcelConnString =
>    "provider=Microsoft.Jet.OLEDB.4.0; data source='" + sFileName + " '; " + "Extended Properties=Excel 8.0;";
>

>then it works fine.
>
>However, if I add the "Hdr=Yes" on the end...
>
>

>string sExcelConnString =
>    "provider=Microsoft.Jet.OLEDB.4.0; data source='" + sFileName + " '; " + "Extended Properties=Excel 8.0;Hdr=Yes";
>

>
>
>I get "Could not find installable ISAM". I googled it but I don't see what the problem is.
>
>Anyone?

Extended Properties , they are expected to be in quotes, like:

string sExcelConnString =
    "provider=Microsoft.Jet.OLEDB.4.0; data source='" + sFileName + " '; " + "Extended Properties=""Excel 8.0;Hdr=Yes""";