Select/Insert/Update/Delete Excel 2007 File and C#
I am using datagridview and i am binding my excel file to datagridview. I am able to read from excel file as well as insert to that file using datagridview. But I am not able to delete and update that file. It's giving error that "Deleting data in a linked table is not supported by this ISAM.". Is there any other best method to perform these operation on excel file using datagridview. Or simply how can I delete, update record in Excel file using datagridview in C#.