Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003

    Unanswered: How can I insert rows into an Excel spreadsheet from inside MS Access?

    I have a simple MS Access database that has a couple of forms and reports. I'd like to create a new form (or perhaps add to a current form) that contains a couple of textboxes, drop-downs, and a "Save" button.

    When this save button is pressed, I'd like Access to open an Excel spreadsheet, find the first empty row (eg. the last row on the bottom) and insert data.

    The idea here is to have Access automatically update a spreadsheet instead of having to do it manually. I don't need to access any existing data in the spreadsheet -- all I want to do is insert data at the bottom of the spreadsheet.

    Can anybody help me out?

    [EDIT] I'm using MS Access/Excel XP, not the 2003 version. [/EDIT]

    Thanks in advance.

  2. #2
    Join Date
    Oct 2003
    I've figured out how to connect to the Excel spreadsheet using ADO (from inside of MS Access), but I can't figure out how to insert data to the end of the spreadsheet...

    I've been looking all day and can't find any examples...

    Can anybody please help me?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts