Forum Discussion
Adding a new record to Excel Spreadsheet through Access Table
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.