Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 7

Displaying posts with tag: Excel (reset)

MySQL for Excel 1.1.1 GA has been released
Employee +1 Vote Up -0Vote Down
posted by Reggie Burnett on Fri 26 Apr 2013 21:05 UTC
Tags:
(edit) mysql, Oracle, Excel, Office

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
Employee +7 Vote Up -0Vote Down
posted by Reggie Burnett on Fri 07 Dec 2012 19:20 UTC
Tags:
(edit) mysql, Oracle, howto, Excel, guide, import

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
Employee +2 Vote Up -0Vote Down
posted by Reggie Burnett on Tue 13 Nov 2012 17:38 UTC
Tags:
(edit) mysql, Oracle, Excel, add-in

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.

Two Cons against NoSQL. Part I.
+1 Vote Up -1Vote Down
posted by Roberto V. Zicari on Tue 30 Oct 2012 16:57 UTC
Tags:
(edit) mysql, postgres, Oracle, Open Source, Uncategorized, sql, ibm, analytics, hadoop, Excel, csv, big data, NoSQL, mongodb, json, riak, voltdb, basho, nosql databases, Cindy Saracco, Clustrix, document stores, Dwight Merriman, InfoSphere BigInsights, John Hugg, New and old Data stores, relational databases, Steve Vinoski
Two cons against NoSQL data stores read like this: 1. It’s very hard to move data out from one NoSQL to some other system, even other NoSQL. There is a very hard lock in when it comes to NoSQL. If you ever have to move to another database, you have basically to re-implement a lot [...]
MySQL for Excel 1.1.0 GA has been released
Employee +2 Vote Up -0Vote Down
posted by Reggie Burnett on Fri 19 Oct 2012 00:34 UTC
Tags:
(edit) mysql, Oracle, Excel, Office

The MySQL Windows Experience Team is proud to announce the release of MySQL for Excel version 1.1.0 GA, one of our newest products contained in the MySQL Installer suite.  This new version introduces the Edit MySQL Data feature.

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

Parse nasty XLS with dynamic ETL
+1 Vote Up -0Vote Down
posted by Matt Casters on Fri 25 Feb 2011 12:07 UTC
Tags:
(edit) Data Integration, metadata, ETL, Kettle, Excel, pentaho data integration, injection, Spreadsheet

Dear Kettle friends,

Last year, right after the summer in version 4.1 of Pentaho Data Integration, we introduced the notion of dynamically inserted ETL metadata (Youtube video here).  Since then we received a lot of positive feedback on this functionality which encouraged me to extend it to a few more steps. Already with support for “CSV Input” and “Select Values” we could do a lot of dynamic things.  However, we can clearly do a lot better by extending our initiative to a few more steps: “Microsoft Excel Input” (which can also read ODS by the way), “Row Normalizer” and “Row De-normalizer”.

Below I’ll describe an actual (obfuscated) example that you will probably recognize as it is equally hideous as simple in it’s horrible complexity.

Take a look at this file:

  [Read more...]
BI users can't wean themselves off Excel
+0 Vote Up -0Vote Down
posted by Jonathan Levin on Thu 28 Feb 2008 03:47 UTC
Tags:
(edit) Excel
I read this article recently about how BI users just really love and are used to their Excel sheets for almost anything they do. My first reaction was "duh". My second reaction was that even I used Excel recently to help me data cleanse some contact information.
Its easy to use, the functions are clear, I can develop my own functions in VBA, I can use colors to see problems with values, etc...
I mean I can bet you that "even" if you use MySQL and you want to play around with the data to see if you can find anything, you would use Excel.

But as the article says, there are some drawbacks in terms of time spent fixing errors and if you use Excel sheets that connect to other Excel sheet and then you go and



  [Read more...]
Showing entries 1 to 7

Planet MySQL © 1995, 2013, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.