I have a MySQL database that collects form entries from an app. I want to capture the MySQL entries and send them to an Excel sheet. Whenever a new row is added to the Excel table, it should add the row to the Excel sheet.
I’ve been able to set up a connection between the MySQL database and Excel and add all the MySQL entries to the Excel sheet, but I’m not sure how to set it up to check for new entries in the MySQL database and then only write those entries as a new row into the Excel sheet.
Any advice on how to accomplish this?