MySQL for Excel Guide  /  Edit MySQL Data in Excel

Chapter 4 Edit MySQL Data in Excel

MySQL for Excel simplifies the tasks of inserting, deleting, and updating database table rows using Microsoft Excel by providing a snapshot of the selected MySQL table that is imported into an Excel worksheet. The edit-session feature works with that detached copy of the data. Any changes made to that copy are translated into SQL statements that are applied to the selected MySQL table.