Last post Aug 23, 2010 04:55 PM by anas
Aug 19, 2010 08:55 AM|shrishail_ashtage|LINK
I have write the code for deleting the data in excel sheet. but we have got the error" Deleting data in a linked table is not supported by this ISAM."
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
Aug 23, 2010 04:55 PM|anas|LINK
Deleting records is not allowed when using oledb provider (like the above code) [http://support.microsoft.com/kb/316934]
In order to delete excel records, you will need to use Excel interop services which exists in "Microsoft.Office.Interop.Excel" namespace.
Here are some examples: