Thursday 7 August 2014

system.data.oledb.oledbexception could not find installable isam


The path name should be like below:

string filename = "C:\\Praveen\\Tasks\\TASK 1\\Mydata.xlsx";
            MyOleCon = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source="+ filename +";Extended Properties=\"Excel 12.0 Xml;HDR=YES;\"");