Iam insert and update the data in Excel sheet.while iam deleting the data it gives the  Error like
 
Deleting data in a linked table is not supported by this ISAM.
 
 
 string excelConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Fileloc + ";Extended Properties=Excel 12.0;Persist Security Info=False";
            OleDbConnection excelConnection = new OleDbConnection(excelConnectionString);
            String cquery1 = "Delete from [data1$] where id=" + Txtid.text;
            OleDbCommand cmd = new OleDbCommand(cquery1, excelConnection);
            excelConnection.Open();
            cmd.ExecuteNonQuery();
            excelConnection.Close();