Deleting Excel Records with ADO


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Deleting Excel Records with ADO

  1. #1
    Saiful Guest

    Deleting Excel Records with ADO


    Hi All

    I am having problem deleting record from an Excel spreadsheet. Whenever I
    try to delete I am getting this error message:-

    [Microsoft][ODBC Excel Driver] Deleting data in a linked table is not suported
    by this ISAM.

    I am making a trimming program to trim my Excel spreadsheet (I had to use
    this) that runs in the background and will keep checking this spreadsheet
    to trim the data inside.

    I hope someone can offer me their advise this matter.

    rgds,
    Saiful

  2. #2
    Paul Clement Guest

    Re: Deleting Excel Records with ADO

    On 3 Aug 2000 20:11:56 -0700, "Saiful" <md-saifulamri_omar@hp.com> wrote:


    Hi All

    I am having problem deleting record from an Excel spreadsheet. Whenever I
    try to delete I am getting this error message:-

    [Microsoft][ODBC Excel Driver] Deleting data in a linked table is not suported
    by this ISAM.

    I am making a trimming program to trim my Excel spreadsheet (I had to use
    this) that runs in the background and will keep checking this spreadsheet
    to trim the data inside.

    I hope someone can offer me their advise this matter.

    Maybe you could post your code?


    Paul ~~~ pclement@ameritech.net
    Microsoft MVP (Visual Basic)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center