Tuesday Apr 22, 2014
Wednesday Apr 09, 2014
By Javier Rivera on Apr 09, 2014
Welcome to another post of the MySQL for Excel team, this time we will talk about another cool feature you can find in our latest release to date (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!
Friday Apr 04, 2014
By Roberto Garcia on Apr 04, 2014
Monday Mar 31, 2014
By Javier Treviño on Mar 31, 2014
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.[Read More]
Thursday Mar 27, 2014
By Javier Treviño on Mar 27, 2014
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 http://dev.mysql.com/downloads/installer/.[Read More]
Tuesday Mar 18, 2014
By Javier Rivera on Mar 18, 2014
Today we're going to talk about one of main features from 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.
Tuesday Mar 11, 2014
By GABMARTINEZ on Mar 11, 2014
Monday Mar 10, 2014
By GABMARTINEZ on Mar 10, 2014
Sunday Mar 09, 2014
By Javier Treviño on Mar 09, 2014
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.[Read More]
Thursday Mar 06, 2014
By Javier Rivera on Mar 06, 2014
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:
Thank you for your support![Read More]
Wednesday Mar 05, 2014
By Roberto Garcia on Mar 05, 2014
Dear MySQL users,
We are proud to announce that we have made the open source version of our Connector/NET 6.8.3 is available as official MySQL Nuget packages.
Currently we have 3 nuget packages which contain:
- MySQL Connector/NET Core
- MySQL Connector/NET for Entity Framework 6
- MySQL Connector/NET Web providers
Monday Feb 10, 2014
By GABMARTINEZ on Feb 10, 2014
Tuesday Feb 04, 2014
By Javier Rivera on Feb 04, 2014
This is the second part of two series of blog posts to setup a SSH connection on Windows from scratch. The first part can be found here.
This article describes in step by step fashion a guide on how to create and configure a SSH Tunnel with port forwarding to a remote MySQL server running FreeSSHd on Windows using Putty locally.
Friday Jan 31, 2014
By Javier Treviño on Jan 31, 2014
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/.[Read More]
Monday Jan 27, 2014
By Javier Rivera on Jan 27, 2014
This article describes in step by step fashion a guide on how to install and configure a SSH server in a MySQL server running on Windows using FreeSSHd.
Here's where you'll hear about all the new and fun stuff we are doing with MySQL on Windows.
- MySQL for Visual Studio 1.2.0 alpha has been released
- MySQL for Excel new features (1.2.0): Edit Connections
- MySQL Connector/NET 6.7.5 has been released
- How To - Guide to editing MySQL data within Excel
- MySQL for Excel 1.2.1 has been released
- How To - Guide to appending data from Excel to an existing MySQL table
- HowTo: MySQL new toolbar inside the Visual Studio IDE
- MySQL for Visual Studio 1.1.4 is available for download
- How To - Guide to exporting data from Excel to a new MySQL table
- MySQL for Excel Main Features Video