Documentation Home
MySQL and Windows
Related Documentation Download this Excerpt

MySQL and Windows  /  MySQL for Excel  /  Edit MySQL Data in Excel

6.5 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.