Windows Experience Team is proud to announce the release of MySQL for Excel
version 1.2.0, the latest addition to the MySQL Installer for
MySQL for Excel is an application plug-in enabling data analysts to very easily access and manipulate MySQL data within Microsoft Excel. It enables you to directly work with a MySQL database from within Microsoft Excel so you can easily do tasks such as:
- Importing MySQL Data into Excel
- Exporting Excel data directly into MySQL to a new or existing table
- Editing MySQL data directly within Excel
MySQL for Excel is installed using the MySQL Installer for Windows.
The MySQL installer comes in 2 versions
- Full (150 MB) which includes a complete set of MySQL products with their binaries included in the download
- Web (1.5 MB - a network install) which will just pull MySQL for Excel over the web and install it when run.
You can download MySQL Installer from our
official Downloads page at http://dev.mysql.com/downloads/installer/.
MySQL for Excel 1.2.0 introduces the following features:
- Edit Connections: MySQL connections can now be
edited from within the MySQL for Excel plugin by right-clicking and choosing
Edit Connection. Before, these connections could only be edited with MySQL
Updates: Previously, only "Pessimistic Updates" were used, which
means that pressing Commit Changes would overwrite changes performed outside of
MySQL for Excel for the edited cells. Both options remain available today, and
optimistic updates are enabled by default. This update type can be set either
as a preference, or toggled per session.
Append Data dialog will now notify you of incompatible types (with visual
warnings) when mapping source Excel columns to target MySQL columns. If a
mismatch is discovered, then the column in the source grid that contains the
mapped Excel data turns red, and selecting this column displays a warning with
text explaining that the source data is not suitable for the mapped target
column's data type.
preview preferences allow you to enable one of the following three options:
SQL statements before they are sent to the Server: View (and optionally) edit
the MySQL UPDATE/INSERT statements before they are committed.
executed SQL statements along with the results: View the statements after they
are committed, which is the current behavior.
not show the MySQL statements: Only show summary information, such as number of
affected rows, and not MySQL statements. This is enabled by default.
Table: The Data Export feature now has the option to only create the table
without inserting the data. To execute, toggle the Export Data button to Create
Table, and then click.
selected schema name is now displayed on top of the MySQL for Excel Database
Object Selection panel.
Advanced Options dialogs opened from the Import, Export and Append Data windows
now immediately apply the option changes, when before the Advanced Options
dialog had to be reopened before the changes could be previewed.
Data sessions can now be saved: Using the new Edit Session preferences, these
sessions were automatically closed after closing an Excel workbook. This data,
such as the Workbench
connection ID, MySQL schema, and MySQL table name, can now be preserved if the
Excel workbook is saved to disk, and available when the Excel workbook is reopened.
tables are created automatically for any data imported from MySQL to an Excel
worksheet with a name like “<schema>.<db_object_name>” where a DB
object can be a MySQL table, view or stored procedure. Options for the Excel
tables creation can be found in the Advanced Options of the Import Data dialog.
The created Excel tables can be referenced for data analysis in Pivot Tables or
release contains the following bug fixes:
- Fixed code that was not detecting an Excel row
deletion but instead was detecting an Excel row change. Now after deleting an
entire row in a worksheet, the row after it would change color to green.
- Bug # 17852774 - EDIT DATA - DELETING A ROW TRIGGERS A DATA CHANGE IN
THE FOLLOWING ROW
access the MySQL for Excel documentation at http://dev.mysql.com/doc/en/mysql-for-excel.html.
find our team’s blog at http://blogs.oracle.com/MySQLOnWindows.
also post questions on our MySQL for Excel forum found at http://forums.mysql.com/list.php?172.
Enjoy and thanks for the support!