part of the new product initiatives of the MySQL on Windows group we released a
tool that makes the task of getting data in and out of a MySQL Database very
friendly and intuitive, and we paired it with one of the preferred applications
for data analysis and manipulation in Windows platforms, MS Excel.
for Excel, an add-in that is installed and accessed from within the MS
Excel’s Data tab offering a wizard-like interface arranged in an elegant yet
simple way to help users browse MySQL Schemas,
Tables, Views and Procedures and
perform data operations against them using MS Excel as the vehicle to drive the
data in and out MySQL Databases.
of the coolest features we had in mind designing MySQL for Excel is simplicity.
MS Excel is simple and easy to work with, thus liked by many Windows users
because they don’t have to be software gurus to use it. We applied the same principle by targeting MySQL for Excel to any kind of user, so
if you are already familiarized with Excel’s interface you will find yourself
working with MySQL data in no time.
MySQL for Excel is shipped within the MySQL Installer as one of the tools in
the suite; if prerequisites are already installed (.NET Framework 4.0, Visual
Studio Tools for Office 4.0 and of course MS Office), installing the add-in
involves a very few clicks and no further setup to use it. Being an Excel
Add-In there is no executable file involved after the installation, running MS
Excel and opening the add-in from its Data tab is all that is required.
connection is opened, the Schema
Selection panel is shown, at the top of it the selected connection (connection
name, hostname/IP and username). Just below, a list of schemas is displayed
where User Schemas are grouped first followed by System Schemas; users can
double-click any selected schema to go to the next panel or select a schema and
clicking the Next > button. Users
can alternatively click on the < Back button to go back to the
Welcome Panel to close the current connection and open a new one; also by clicking
New Schema action label they can create an empty new schema.
schema is opened the DB Object Selection
panel is shown, this is actually the place where the fun stuff happens; from
here users are able to perform actions against MySQL Tables, Views and Procedures.
actions available here are about importing data from a MySQL Table, View or
Procedure to Excel, exporting Excel data to a new MySQL Table, appending Excel
data to an existing MySQL Table or editing a MySQL Table’s data by using an
Excel Worksheet as a user interface to update data in any row/column, insert
new rows or delete existing rows in a very easy and friendly way.
blog posts will follow describing all of these actions, so stay tuned!
that your feedback is very important for us, so drop us a message: