Using Excel to Analyze MySQL Data
Linked by Thom Holwerda on Fri 9th Jun 2006 11:07 UTC, submitted by Jane Walker
Databases "You might be surprised to know that you can connect Excel to a database, and this isn't limited to databases running Microsoft's SQL. Excel can connect to practically any mainstream database (MySQL, PostgreSQL, Oracle and others), provided that the database offers an ODBC (Open DataBase Connectivity) driver. In this article, you'll learn how to connect MySQL to Excel."
E-mail Print r 0   15 Comment(s) http://osne.ws/bgm
Order by: Score:
Add Comment Post a Comment
Yeah!
by audun on Fri 9th Jun 2006 11:35 UTC
audun
Member since:
2005-07-13

I once used excel to recover a damaged Access database.. It worked very well, and weeks of work were saved. (We had no backup)

Reply Score: 1

RE: Yeah!
by rockwell on Fri 9th Jun 2006 14:45 UTC in reply to "Yeah!"
rockwell Member since:
2005-09-13

// ... (We had no backup)//
bet that was the last time that happened ... right?

Reply Score: 2

Well, duh...
by RenatoRam on Fri 9th Jun 2006 13:05 UTC
RenatoRam
Member since:
2005-11-14

people routinely use odbc connections from excel and access to whatever remote databases.
Most users simply use the data without even knowing it resides on an Oracle or AS400 machine, but... ODBC is not really news, is it?

Reply Score: 1

RE: Well, duh...
by jcinacio on Fri 9th Jun 2006 13:39 UTC in reply to "Well, duh..."
jcinacio Member since:
2006-03-12

"You might be surprised to know that you can connect Excel to a database"

Actually, i'm not surprised at all.

If i'm not mistaken, you can do this since at least 97...

Edited 2006-06-09 13:40

Reply Score: 2

ehmm..
by JamesTRexx on Fri 9th Jun 2006 15:51 UTC
JamesTRexx
Member since:
2005-11-06

/nitpickmode on
connect MySQL to Excel
I know people using Excel like a database, but to connect MySQL to Excel seems a bit over the top.
On the other hand, if you're talking about connecting Excel to MySQL...
/nitpickmode off :-P

Reply Score: 1

Well .. theoretically
by ma_d on Fri 9th Jun 2006 17:02 UTC
ma_d
Member since:
2005-06-29

You can do anything with Excel that you can do with any programming language ... Excel is turing equivalent...

Reply Score: 2

RE: Well .. theoretically
by Cloudy on Sat 10th Jun 2006 05:12 UTC in reply to "Well .. theoretically"
Cloudy Member since:
2006-02-15

you wouldn't by any chance haved a turing machine implemented as an excel macro, would you. ;)

Reply Score: 1

poohgee
Member since:
2005-08-13

*Cough* sorry not really surprised - I guess its just a feature rarely used as its not the common office task .

:)

Reply Score: 1

Not that it matters...
by kernelpanicked on Fri 9th Jun 2006 21:53 UTC
kernelpanicked
Member since:
2006-02-01

...because nobody cares, but that other office suite, you know the one that doesn't suck, can do this too.

Reply Score: 1

Question in my mind....
by jbalmer on Sat 10th Jun 2006 10:23 UTC
jbalmer
Member since:
2005-12-18

The big question is if it can be done in excel, can you do it in openoffice spreadsheet as well. And if so do we still require ODBC bridge to connect to the mysql database...

Reply Score: 1

RE: Question in my mind....
by mipeligro on Sat 10th Jun 2006 22:47 UTC in reply to "Question in my mind...."
mipeligro Member since:
2006-06-03

ODBC is a standard for how you access a database from an application. Open Office does use it to access MySQL databases.

Reply Score: 2

RE: Question in my mind....
by frankr on Sun 11th Jun 2006 11:14 UTC in reply to "Question in my mind...."
frankr Member since:
2006-06-11

Yes, you can pull data from MySQL into OpenOffice Calc. I have done it with both the ODBC and JDBC connectors for MySQL. You want to look at the creating a data source in OO Base and then use the DataPilot features in OO Calc.

Reply Score: 1

What's new about that?
by MatzeLoCal on Sat 10th Jun 2006 13:10 UTC
MatzeLoCal
Member since:
2005-11-12

This can be done since years..

@RenatoRam: Jup, it's possible to connect to a DB2/UDB, but it can screw it up badly. No damage or so, but the amount of allocated memory for each session is horrible.

Reply Score: 1

Well...
by Ralf. on Sat 10th Jun 2006 16:30 UTC
Ralf.
Member since:
2005-08-13

since Excel can only display about 65000 rows, this is only suitable for "game" database environments.

Reply Score: 1

:-S
by nealsaferstein on Mon 12th Jun 2006 03:29 UTC
nealsaferstein
Member since:
2006-06-03

Actually, i'm not surprised at all.

Reply Score: 1

Add Comment Post a Comment