X

MySQL and MySQL Community information

  • June 9, 2014

MySQL for Excel 1.3.0 Beta has been released

Javier Ignacio Trevino Cobos
Software Development Manager

The MySQL Windows Experience Team is proud to announce
the release of MySQL for Excel version 1.3.0
This is a beta 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 beta version the MySQL for Excel product can
be downloaded only by using the product standalone installer at this link http://dev.mysql.com/downloads/windows/excel/

Your feedback on this beta version is very well appreciated, you can raise bugs on the MySQL bugs page or give us your comments on the MySQL for Excel forum.


Changes in MySQL for Excel 1.3.0 (2014-06-06, Beta)

This section
documents all changes and bug fixes applied to MySQL for Excel since
the release of 1.2.1. Several new features were added, for more
information see What Is New In MySQL for Excel (http://dev.mysql.com/doc/refman/5.6/en/mysql-for-excel-what-is-new.html).

Known
limitations:

  • 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.
  • <CTRL> + <A> cannot be used to select all database objects. Either <SHIFT> + <Arrow Key> or <CTRL> + click must be used instead.
  • PivotTables 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

  • Imported
    data can now be refreshed by using the native Refresh feature.
    Fields in the imported data sheet are then updated against the
    live MySQL database using the saved connection ID.
  • Functionality was added to import data directly into PivotTables,
    which can be created from any Import operation.
  • Multiple
    objects (tables and views) can now be imported into Excel, when
    before only one object could be selected. Relational
    information is also utilized when importing multiple
    objects.
  • All options
    now have descriptive tooltips. Hovering over an option/preference displays helpful information about its use.
  • A new
    Export Data, Advanced Options option was added that shows all
    available data types in the Data Type combo box, instead of
    only showing a subset of the most popular data types.
  • The option
    dialogs now include a Refresh to Defaults button that resets
    the dialog's options to their defaults values. Each option dialog is set individually.
  • A new Add
    Summary Fields for Numeric Columns
    option was added to the
    Import Data dialog that automatically adds summary fields for
    numeric data after the last row of the imported data. The
    specific summary function is selectable from many options,
    such as "Total" and "Average."
  • A new
    collation option was added for the schema and table creation
    wizards. The default schema collation is "Server Default", and the default table collation
    is "Schema Default". Collation
    options may be selected from a drop-down list of all available
    collations.

Quick links:

Enjoy and thanks for the support! 

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.