I have write the code for deleting the data in excel sheet. but we have got the error[color=Blue]" Deleting data in a linked table is not supported by this ISAM."[/color]
below I paste some code snippest.
string strDelete = "Delete from [" + strSheetName + "$]";
cmdExcel.Connection = con;
cmdExcel.CommandType = CommandType.Text;
cmdExcel.CommandText = strDelete;
Please can anybody this answer.It is urgent