Skip to content

Using Excel to analyze MySQL data

Posted by Lenz Grimmer on
Just stumbled over this article, which might come in handy for our Microsoft Office users out there: "Using Excel to analyze MySQL data" by Jason Gilmore explains how to set up the MySQL Connector/ODBC and connecting to a MySQL database using Microsoft Excel.

If you're a Linux user, this article on NewsForge covers a similar topic, using OpenOffice.org

to connect to a MySQL Server.

Update: Thanks to Guillermo Roditi for pointing out that both links pointed to the same article - now fixed. Sorry about that.

Trackbacks

No Trackbacks

Comments

Display comments as Linear | Threaded

Guillermo Roditi on :

Add Comment

Enclosing asterisks marks text as bold (*word*), underscore are made via _word_.
Standard emoticons like :-) and ;-) are converted to images.
HTML-Tags will be converted to Entities.
E-Mail addresses will not be displayed and will only be used for E-Mail notifications.

To prevent automated Bots from commentspamming, please enter the string you see in the image below in the appropriate input box. Your comment will only be submitted if the strings match. Please ensure that your browser supports and accepts cookies, or your comment cannot be verified correctly.
CAPTCHA

Form options
tweetbackcheck