开发者

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 advance


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

0

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜