delete record from excel sheet

ashtage

Hello,

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;

cmdExcel.ExecuteNonQuery();


Please can anybody this answer.It is urgent