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.
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 add summary fields to our data imports to excel easily.
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: …
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.
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: http://dev.mysql.com/downloads/windows/excel/
In this blog post regarding MySQL for Excel features included since version 1.2.0, we are going to talk about a new option that is used along with Edit MySQLData operations; very useful when editing data in a multi-user environment. If you are not familiar with editing MySQL data it is very advisable that you visit our thorough blog post about that topic: How To - Guide to editing MySQL data within Excel.[Read more]
In this blog post we are going to cover a pretty useful piece of functionality introduced since MySQL for Excel 1.2.0.
There could be times when users may want to see exactly what SQL queries are being generated either before they are sent to the server, so corrections can be made if the query does not look as intended, or after they are sent to the server to obtain additional information or for debugging purposes.
Starting with MySQL for Excel 1.2.0, new global options were added to modify the behavior of the moment when SQL queries that affect a MySQL database are shown to the users. The Global Options dialog can be accessed from the Options button located in the Schema Selection panel or the DB Objects Selection one as shown below.
Remember you can install the latest GA or maintenance version using the …[Read more]
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.
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/
In this blog post we are going to talk about one of the features included since MySQL for Excel 1.2.0, we introduced some advanced options for the Import MySQL Data operation regarding Excel tables. 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.
Since the first release you were allowed to open a session to
directly edit data from a table at Excel on a worksheet and see
those changes reflected immediately on the database. You were
also capable of opening multiple sessions to different tables at
the same time (when they belong to the same schema). The problem
was that if for any reason you were forced to close Excel or the
Workbook, you had no way to reopen those sessions and continue
where you left off.
Today we are going to talk about another feature included since MySQL for Excel 1.2.0 which allows you to save and restore edit sessions. Remember this product and many others can be downloaded directly from our MySQL Installer downloads page and installed for free.
Welcome to another post of the MySQL for Excel team, this
time we will talk about another cool feature you can find since
version 1.2.0, which can be downloaded directly from
our MySQL Installer downloads page.
If you want to learn how you can easily edit connections directly from the main MySQL for Excel panel now please read this post.
If you would like to give us your feedback and propose new features you would like to see on future versions of MySQL for Excel we encourage you to please visit our forum and leave us a comment.
Thank you for your support!
In previous posts we have talked about importing data from MySQL to Excel, exporting data from Excel to a new or to a existing MySQL table (via the Export Data or Append Data operations) which are common tasks to be performed against MySQL tables. In this post we will talk about possibly the coolest feature in MySQL for Excel which is the Edit Data operation which allows the retrieval of a MySQL table's data to an Excel worksheet so the data can be edited, deleted or inserted in new rows and those changes saved back to the MySQL database in a friendly and intuitive way, and more importantly, without the need of writing SQL queries making it accessible to any kind of user.
You will learn in this guide how to do it and all the details about the Edit Data feature in MySQL for Excel.