Problem to delete table data in Excel
I 'm trying to delete Excel table data by command
DELETE FROM [Phones_map$]
Then I got exception Additional information: Deleting data in a linked table is not supported by this ISAM.
Here is connection string: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=myfile.xls;Extended Properties="Excel 8.0;HDR=No;IMEX=0"
Is 开发者_开发百科another SQL command supported by Excel for table data deletion ? I tried TRUNCATE table , but it does not supported
Thanks in advanceI think the error message gives you your answer - you can't delete the data.
精彩评论