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]