页: 1
[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