Refreshing imported MySQL data with MySQL for Excel
By Javier Rivera-Oracle on Aug 15, 2014
Welcome to another blog post from the MySQL for Excel Team. Today we're going to talk about a new feature included since MySQL for Excel 1.3.0, you can install the latest GA or maintenance version using the MySQL Installer or optionally you can download directly any GA or non-GA version from the MySQL Developer Zone.
As some users suggested in our forums we should be maintaining the link between tables and Excel not only when editing data through the Edit MySQL Data option, but also when importing data via Import MySQL Data. Before 1.3.0 this process only provided you with an offline copy of the Table's data into Excel and you had no way to refresh that information from the DB later on. Now, with this new feature we'll show you how easy is to work with the latest available information at all times. This feature is transparent to you (it doesn't require additional steps to work as long as the users had the Create an Excel Table for the imported MySQL table data option enabled. To ensure you have this option checked, click over Advanced Options... after the Import Data dialog is displayed).
The current blog post assumes you already know how to import data into excel, you could always take a look at our previous post How To - Guide to Importing Data from a MySQL Database to Excel using MySQL for Excel if you need further reference on that topic.
After importing Data from a MySQL Table into Excel, you can refresh the data in 3 ways.
1. Simply right click over the range of the imported data, to show the pop-up menu:
Click over the Refresh button to obtain the latest copy of the data in the table.
2. Click the Refresh button on the Data ribbon:
3. Click the Refresh All button in the Data ribbon (beware this will refresh all Excel tables in the Workbook):
Please take a note of a couple of details here, the first one is about the size of the table. If by the time you refresh the table new columns had been added to it, and you originally have imported all columns, the table will grow to the right. The same applies to rows, if the table has new rows and you did not limit the results , the table will grow to to the bottom of the sheet in Excel.
The second detail you should take into account is this operation will overwrite any changes done to the cells after the table was originally imported or previously refreshed:
Now with this new feature, imported data remains linked to the data source and is available to be updated at all times. It empowers the user to always be able to work with the latest version of the imported MySQL data. We hope you like this this new feature and give it a try!
Remember that your feedback is very important for us, so drop us a message with your comments, suggestions for this or other features and follow us at our social media channels:
- MySQL on Windows (this) Blog: https://blogs.oracle.com/MySqlOnWindows/
- MySQL for Excel forum: http://forums.mysql.com/list.php?172
- Facebook: http://www.facebook.com/mysql
- YouTube channel: https://www.youtube.com/user/MySQLChannel