开发者

Problem to delete table data in Excel

开发者 https://www.devze.com 2023-02-18 00:18 出处:网络
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.

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 advance


I think the error message gives you your answer - you can't delete the data.

0

精彩评论

暂无评论...
验证码 换一张
取 消