The MySQL Windows Experience Team is proud to announce
the release of MySQL for Excel version 1.3.1. This is a RC release for 1.3.x.
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
As this is a Release Candidate version the MySQL for Excel product can
be downloaded only by using the product standalone installer at this link:
Changes in MySQL for Excel 1.3.1 (2014-07-02, Release Candidate)
This section documents all changes and bug fixes applied
to MySQL for Excel since the release of 1.3.0. Several new features were added
the 1.3.x branch, for more information see What Is New In MySQL for Excel.
- Upgrading from
versions MySQL for Excel 1.2.0 and lower is not possible due
to a bug fixed in MySQL for Excel 1.2.1. In that scenario, the
old version (MySQL for Excel 1.2.0 or lower) must be
uninstalled first. Upgrading from version 1.2.1 works correctly.
are normally placed to the right (skipping one column) of the
imported data, they will not be created if there is
another existing Excel object at that position.
Functionality Added or Changed
- When reopening
a saved Excel workbook that contains imported MySQL data,
MySQL for Excel attempts to reconnect the Excel tables with
the corresponding MySQL databases where the imported MySQL data was
imported from. If the MySQL connections are not found, then a
new dialog prompts you to either ignore, create, or delete the
missing connections. Ignore allows you to work offline, and
the dialog will open the next time the Excel workbook is
opened. (Bug #18961860, Bug #72966)
- <CTRL> + <A> now selects all tables and views in the Database Objects selection panel. (Bug #18961544, Bug #72963)
- Data could not
be imported from a remote MySQL server.
- The Edit
Connection dialog was not populated with information from the
selected MySQL connection.
- In Excel 2013,
importing the same table twice in the same Excel
worksheet failed after deleting the Excel table linked to in the
- Data could not
be imported to the left of previously imported data if the
new data intersected with the existing import.
importing data, clicking Refresh All from the Data tab would fail to
refresh the data, and it generated an "Initialization of the data source failed" error.
- When exporting
data, a duplicate entry was sent to the MySQL server when
data was exported to a new table with the First Row Contains
Column Names checkbox deselected. The generated error was
similar to "Error while inserting rows... MySQL Error 1062:
Duplicate entry '1' for key 'PRIMARY'".
- With the
Create a Pivot Table with the imported data option enabled, Data
Import failed to create a PivotTable for tables that contained
a large data set.
- When importing
tables, the Pick related Tables or Views feature did
not function in Excel 2007 or Excel 2010, but did in Excel 2013.
- For new
columns, the Export Data dialog would not accept manually typed
in data types that contained a parenthesis, such as ENUM.
- Line and
LinearRing were removed from the list of valid data types, so they
no longer appear in the Export Data dialog's data type combo box.
- Hovering over
elements in the MySQL connecting and object listing could
cause the text of each item to be bold.
- Imported data
would not refresh if the table name was changed in Excel
during the import. The table name is no longer used to verify the
- Edit Sessions
would fail to restore with sessions that contained
tables with zero DATETIME values. Edit Sessions
would also fail to restore when MySQL for Excel was started on
a currently opened Excel workbook.
- Attempting to
import a table with ENUM values would fail with an "Input
string was not in a correct format." error.
- Bug #18728748
- Bug #18962214
- Bug #72970
Enjoy and thanks for the support!