[AccessD] OT - Deleting a row in an excel named range using ADO

Hi Mark

> I have a named range in Excel (XP) and am able to add and edit records
> within it easilly using ADO. However, when I try and delete a record I
> get run time error -2147217887 and a message saying "Deleting data in a
> linked table is not supported by this ISAM."

> If I run "rs.Supports(adDelete)" it returns true???

I believe the error message is true.

You have to empty the rows of the range in a manner like this:

   With rst
     .MoveFirst
     While Not .EOF
       .Edit
       For Each fld In .Fields
         fld.Value = Null
       Next fld
       .Update
       .MoveNext
     Wend
   End With

/gustav