Forum Discussion
Adding a new record to Excel Spreadsheet through Access Table
I have an MS Access form, once all fields are filled the form data goes into Access table. Now I want to add the same data into an Excel Spreadsheet simultaneously as well. How can I achieve this?
3 Replies
Again, while we can offer ideas, there's no real certainty that they address the actual requirement, being as vague as it was.
It is not possible, under standard linking, to update Excel spreadsheets directly, although it can be done with a properly designed Update query. That means that if you really have a valid business reason to duplicate data in two locations, you could implement that query and execute it as needed.
Or if you want only to dump out a copy of the entire table, or tables, into a spreadsheet, that's also an alternative and writing the VBA to do that would be a common procedure.
But we simply don't know yet, which is more appropriate to this particular situation, and even whether it's a viable thing to do in the first place. It depends on a) what data you need to export, and b) why you want to do it.
Thanks for filling in the details.
- you can always Export the Table/Query to a Spreadsheet.
While I agree in essence with the suggestion not to just automatically duplicate records like that, I am always curious about the business rules which underlie the desire to do it. What value is obtained by duplicating data? How does that benefit your organization?
