Go4Expert

Go4Expert (http://www.go4expert.com/)
-   MS Access (http://www.go4expert.com/forums/ms-access-forum/)
-   -   Deleting rows in excel using a query? (http://www.go4expert.com/forums/deleting-rows-excel-using-query-t1553/)

<Z3N> 7Oct2006 01:55

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:

shabbir 9Oct2006 06:18

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 20:37.