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?
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?