1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

Deleting rows in excel using a query?

Discussion in 'MS Access' started by <Z3N>, Oct 6, 2006.

  1. <Z3N>

    <Z3N> New Member

    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:
  2. shabbir

    shabbir Administrator Staff Member

    You have some relationships on the tables you are trying to delete.

Share This Page