delete record from excel sheet


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
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!