Could not find installable ISAM

[kjosh]

Hi, Iam Connecting to Excel 2003. I used the following connecton: string str = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\projects\empdata.xls;Extended Properties=Excel 11.0;"; OleDbConnection con = new OleDbConnection(str); con.Open(); Iam getting this exception:Could not find installable ISAM Please help me. Thanks in advance

[Christian Wulff]

Hi, try

string str = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\projects\empdata.xls;Extended Properties=""Excel 8.0"";";

I use Office 2003, too, but only Excel 8.0 works for me.

[kjosh]

Hi, Thank you very much.It is working.