Showing entries 21 to 30 of 34
« 10 Newer Entries | 4 Older Entries »
Displaying posts with tag: Excel (reset)
MySQL for Excel 1.2.1 has been released

The MySQL Windows Experience Team is proud to announce the release of MySQL for Excel version 1.2.1.

MySQL for Excel 1.2.1 is a maintenance release for 1.2.x containing a handful of bug fixes and the following minor features:

  • When MySQL Workbench is not installed, MySQL connections are now automatically created for discovered MySQL services. If MySQL Workbench is later installed, these connections are not migrated over to MySQL Workbench as MySQL Workbench also creates connections for discovered MySQL services.

You can download MySQL for Excel 1.2.1 from our official Downloads page at http://dev.mysql.com/downloads/windows/excel as a standalone MSI, and it will be available shortly in the MySQL Installer for Windows that can be downloaded from …

[Read more]
How To - Guide to appending data from Excel to an existing MySQL table

Today we're going to talk about one of the main features in MySQL for Excel. There may be times when you have a MySQL Database table that you want to add new rows to. In this blog post we're going to show you how you can do that from within Excel directly easily using the Append Excel Data to Table feature.

Always remember MySQL for Excel can be downloaded and installed directly for free, from our MySQL Installer downloads page.

Your feedback is very important for us, please drop us a message and follow our social networks:

[Read more]
How To - Guide to exporting data from Excel to a new MySQL table

There may be times when you need to create a new table in MySQL and feed it with data from another database, the Internet or from combined data sources. MS Excel is commonly used as the bridge between those data sources and a target MySQL database because of the simplicity it offers to organize the information to then just dump it into a new MySQL table. Although the last bit sounds trivial, it may actually be a cumbersome step, creating ODBC connections within Excel through Microsoft Query may not help since these are normally created to extract data from MySQL into Excel, not the opposite. What if you could do this in a few clicks from within Excel after making your data ready for export to a MySQL database?

With MySQL for Excel you can do this and this guide will teach you how easy it is.

MySQL for Excel Main Features Video

We are proud to announce our first MySQL for Excel video is now available at the MySQL youtube channel.

Please give it an eye and get to know about the main features of MySQL for Excel (Import, Export, Append and Edit).

To view the video on youtube click over the image shown in below:


We always look forward to hear what new features you will like to see on future versions of MySQL for Excel so we encourage you to please visit our forum and let us know. Also, follow us at:

[Read more]
MySQL for Excel 1.2.0 has been released

The MySQL 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 Windows.

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. You can download MySQL Installer from our official Downloads page at http://dev.mysql.com/downloads/installer/.

MySQL for Excel new features (1.2.0): Auto refresh Import Data, Export Data and Append Data dialogs

This post is about one of the new features included in the latest MySQL for Excel release to date (1.2.0) which can be Installed directly from our MySQL Installer.

Since the first release you were allowed to Import and Append data from Excel to a MySQL database, and also to import data from the MySQL database to an Excel Worksheet.
All these windows handle small previews of the data you were working with, and some settings about how the data should be treated can be found by clicking the Advanced Options button on them.

The problem many users found was that sometimes when they changed these options, the small previews did not reflected the changes being made on them, and they had to close and reopen the windows to see if their changes were what they actually wanted or how the data was being treated with the new format.

Now on this …

[Read more]
MySQL for Excel 1.1.3 has been released

The MySQL Windows Experience Team is proud to announce the release of MySQL for Excel version 1.1.3, the  latest addition to the MySQL Installer for Windows.

MySQL for Excel 1.1.3 is a maintenance release containing a handful of bug fixes and the following minor features:

  • Upon saving a Workbook containing Worksheets in Edit Mode, the user is asked if he wants to exit the Edit Mode on all Worksheets before their parent Workbook is saved so the Worksheets are saved unprotected, otherwise the Worksheets will remain protected and the users will be able to unprotect them later retrieving the passkeys from the application log after closing MySQL for Excel.
  • Added background coloring to the column names header row of an Import Data operation to have the same look as the one in an Edit Data operation (i.e. gray-ish background).
  • Connection passwords can be …
[Read more]
MySQL for Excel 1.1.1 GA has been released

The MySQL Windows Experience Team is proud to announce the release of MySQL for Excel version 1.1.1 GA, the  latest addition to the MySQL Installer for Windows.

MySQL for Excel 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

Version 1.1.1 is a maintenance release containing a handful of bug fixes.

You can download it from our official Downloads page at http://dev.mysql.com/downloads/installer/.

How To - Guide to Importing Data from a MySQL Database to Excel using MySQL for Excel

Fetching data from a database to then get it into an Excel spreadsheet to do analysis, reporting, transforming, sharing, etc. is a very common task among users. This task can be accomplished in several different ways and with different tools getting the same result; but users may find the process rather complicated, too technical and lengthy. With MySQL for Excel the task of importing data from a MySQL database to an Excel spreadsheet becomes an easy one and accessible to all types of users.  Here is a quick guide describing how to import data to Excel using MySQL for Excel.

Introducing MySQL for Excel

MySQL for Excel is one of the newest products of the MySQL on Windows group broadening the way MySQL data can be accessed in an easy and friendly way from within MS Excel. This is the first blog post of a small series aimed to present the current features of this great product and to get feedback from users about ideas for enhancements.

Showing entries 21 to 30 of 34
« 10 Newer Entries | 4 Older Entries »