Updating data using MySQL for Excel
Once data is inserted into an Excel workbook, we may want to update the MySQL database based on changes made to the data. To help with this, MySQL for Excel implements functionality for editing data. This allows us to edit data in Excel and save the changes back to MySQL.
In the next exercise, we will bring in data from MySQL and place it on a new worksheet. This data can be edited, and the updated data can be written back to the MySQL database. The ability to edit MySQL data and save it back to the database helps you to maintain your data without the need to develop complicated forms.
Exercise 12.05 – updating MySQL data – employees
MySQL for Excel will insert the data into a new worksheet if you select the editing option. In this exercise, we will add the employee data:
- Activate the MySQL panel by clicking DATA and MySQL for Excel:
Figure 12.18: Location of the MySQL for Excel button in...
