1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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

    shabbir Administrator Staff Member

    Joined:
    Jul 12, 2004
    Messages:
    15,285
    Likes Received:
    364
    Trophy Points:
    83
    You have some relationships on the tables you are trying to delete.
     

Share This Page