Deleting rows in excel using a query?
I'm using this connection string to connect to an Excel file :
db.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\ExcelFile.xls;Extended Properties=""Excel 8.0;HDR=Yes;IMEX=0"""
I'm running this query to delete all the records from table [Mytable$] :
rs.open "DELETE * FROM [Mytable$]"
I'm getting this error :
Deleting data in a linked table is not supported by this ISAM
Is there way to DELETE excel rows from vb? :rolleyes:
Re: Deleting rows in excel using a query?
You have some relationships on the tables you are trying to delete.
|All times are GMT +5.5. The time now is 10:39.|