By Javier Rivera-Oracle on Jan 13, 2014
This post is about one of the new features included in the latest MySQL for Excel release to date (1.2.0) which can be Installed directly from our MySQL Installer.
Since the first release you were allowed to Import and Append data from Excel to a MySQL database, and also to import data from the MySQL database to an Excel Worksheet.
All these windows handle small previews of the data you were working with, and some settings about how the data should be treated can be found by clicking the Advanced Options button on them.
The problem many users found was that sometimes when they changed these options, the small previews did not reflected the changes being made on them, and they had to close and reopen the windows to see if their changes were what they actually wanted or how the data was being treated with the new format.
Now on this version, a smart-refresh has been added to these screens to provide real-time feedback on how the data is being parsed. Check the full blog post for more details!