I have an Access database where the users put in orders. After they put in an order they want the data to be saved to an Excel spreadsheet. I know how to do that but where I am getting stuck is how to tell Access in VBA to append this new line of Access data to the first available excel row.
The users put orders in one at a time and could take many minutes between each order to enter the next into the Access database. Plus other users may put in orders.
They do not want to build this at the end of the day in one shot, they want each order, as added to go right into the excel spreadsheet.
I could probably make a table in Access with one field that remembers what line in excel was just used but I would think there has to be a more elegant way?