DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Excel updating problem

  1. #1
    Join Date
    Nov 2005

    Excel updating problem

    Firstly I wish a nice christmas everyone,

    My problem is a about excel updating.
    I have VB6 and a excel file. I just want to add a new row to this excel sheet's available first row. Like this;


    I'm trying to add a new row that start with 126 and goes with sth like in example.
    I took my sheet in a recordset.

    First I thought I must find the last line. I must find the value "125" but when I say rcset.movelast it caused an error (80040e24' Rowset does not support fetching backward)

    I really need some help. Plz help me...
    Just show me the way, or an example code will be great. Thanks...

  2. #2
    Join Date
    Dec 2003
    You don't need to find the last row. Just use AddNew (which is optional in ADO) and Update. Also, open your Recordset with a CursorType other than forward-only (which is the default).

    You can find an example at the below link. Also make sure you're using the latest Jet service pack as the article specifies.
    Microsoft MVP (Visual Basic)

  3. #3
    Join Date
    Nov 2005
    Thank you very much pclement. Example is the thing that I really need.

Similar Threads

  1. Newbie: Exporting Database to Excel from VB
    By Magic in forum VB Classic
    Replies: 26
    Last Post: 12-15-2005, 11:53 AM
  2. Replies: 2
    Last Post: 10-09-2002, 09:58 AM
  3. Replies: 0
    Last Post: 07-08-2002, 11:37 AM
  4. ANN: Active XL Report 4.1 - Excel reporting with practically no coding
    By Alexander Frolov [Afalina Co., Ltd.] in forum vb.announcements
    Replies: 0
    Last Post: 06-24-2002, 12:13 PM
  5. ANN: Active XL Report 4.0 - Excel reporting with practically no coding
    By Afalina Co., Ltd. in forum vb.announcements
    Replies: 0
    Last Post: 04-01-2002, 10:39 AM

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
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

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