Hi everyone
when i try to run the following code I Get the error "Couldnot Find Installable ISAM"
I Have tried following connection strings
string strConn = "Provider=Microsoft.ACE.OLEDB.12.0;" + "D:\\SudhaPractice\\ExcelDBPractice\\ExcelDBPractice\\bin\\Debug\\ExcelDBPractice.xlsx;" + "Extended Properties=Excel 8.0;";
// System.Data.OleDb.OleDbConnection MySQLConnection = new System.Data.OleDb.OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\SudhaPractice\ExcelDBPractice\ExcelDBPractice\bin\Debug\ExcelDBPractice.xlsx;Extended Properties=Excel 8.0;HDR=YES;""");
// System.Data.OleDb.OleDbConnection MySQLConnection = new System.Data.OleDb.OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\SudhaPractice\ExcelDBPractice\ExcelDBPractice\bin\Debug\ExcelDBPractice.xlsx;Extended Properties=Excel 12.0;HDR=YES");
System.Data.OleDb.OleDbCommand MySQLCommand = new System.Data.OleDb.OleDbCommand("SELECT * FROM [Sheet1$]", MySQLConnection);
System.Data.OleDb.OleDbConnection MySQLConnection = new System.Data.OleDb.OleDbConnection(strConn);
System.Data.OleDb.OleDbDataAdapter da = new System.Data.OleDb.OleDbDataAdapter(MySQLCommand);
DataSet ds = new DataSet();
da.Fill(ds);