Dear MySQL users,
The MySQL Windows Experience Team is proud to announce the
release of MySQL for Excel version 1.3.8. This is a maintenance
release for 1.3.x. It can be used for production
environments.
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 (400 MB) which includes a complete set of MySQL products
with
their binaries …
Dear MySQL users,
The MySQL Windows Experience Team is proud to announce the release of MySQL for Excel version 1.3.7. This is a maintenance release for 1.3.x. It can be used for production environments.
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 …
[Read more]The MySQL Windows Experience Team is proud to announce the release of MySQL for Excel version 1.3.5. This is a maintenance release for 1.3.x. It can be used for production environments.
MySQL for Excel is an application add-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 …
[Read more]The MySQL Windows Experience Team is proud to announce the release of MySQL for Excel version 1.3.4. This is a maintenance release for 1.3.x. It can be used for production environments.
MySQL for Excel is installed using the MySQL Installer for Windows which 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/. The MySQL for Excel product can also be downloaded by using the product standalone installer found at this link …
[Read more]In a previous blog post (Importing related MySQL tables into an Excel Data Model using MySQL for Excel) we covered in detail how an Excel Data Model can be created containing tables and their relationships so the data can be analyzed in Excel via a PivotTable. In this blog post we are going to talk about one of the features included since MySQL for Excel 1.3.0 that allows you to create PivotTables for data imported from MySQL tables, views or stored procedures, or more importantly for the whole Excel Data Model if it is created.
Remember 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 …
[Read more]In this blog post we are going to talk about one of the features included since MySQL for Excel 1.3.0.
Importing MySQL data into Excel is a common and important operation in MySQL for Excel. There may be times when you need to analyze the data stored in several MySQL tables or views, (possibly in an ExcelPivotTable which will be the subject of a future blog post), and to do it you need to dump the data into Excel as the first step. Starting with MySQL for Excel 1.3.0 we introduced a feature that allows you to import the data from multiple MySQL tables or views in a single operation.
Remember 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 …
[Read more]
Welcome to another blogpost from the MySQL for Excel Team. This
time we're going to talk about a new feature included
since MySQL for Excel 1.3.0, now we
maintain the link between imported Excel tables
and its data source. Now, with this new feature we'll show you
how easy is to work with the latest available information at all
times.
We would like to remind you, our latest GA or maintenance version can be installed using the MySQL Installer or optionally you can download directly any GA or non-GA version from the MySQL Developer Zone. 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:
…[Read more]In this blog post we are going to talk about one of the features included since MySQL for Excel 1.3.0, MySQL for Excel has always let you create new schemas and tables in a MySQL database, in versions lower than 1.3.0 these were created with the default character set and collation defined in the MySQL server. Starting with version 1.3.0 we introduced several features regarding collations:
- New drop-downs were added that let you to override the default collation for new MySQL schemas and tables.
- Default collations for each schema can be shownin the schemas list below the schema names.
- The SQL queries for schemas creation can be previewed or displayed (depending on its global setting).
Remember you can install the latest GA or maintenance version using the …
[Read more]
Welcome to another blog post from the MySQL for Excel
Team. Today we're going to talk about a new feature included
since 1.3.0, remember you can always install the latest GA
or maintenance version using the MySQL Installer also you can
download directly any GA or non-GA version from the MySQL Developer Zone.
In this post we will learn how to reset several advanced options
to their default values.
Remember that your feedback is very important for us, please 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: …
In this blog post we are going to talk about one of the features included since MySQL for Excel 1.3.0, a new advanced option was added to the Export Data dialog to show all available MySQL data types on its Data Type combo-box to override its default behavior that shows only the most commonly used data types.
Remember 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.