Deleting rows in excel using a query?

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

  1. <Z3N>

    <Z3N> New Member

    Joined:
    Oct 6, 2006
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    0
    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:
     
    <Z3N>, Oct 6, 2006
    SHARE #1
  2. shabbir

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,375
    Likes Received:
    388
    Trophy Points:
    83
    You have some relationships on the tables you are trying to delete.
     
    shabbir, Oct 9, 2006
    SHARE #2

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice