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."
Thread beginning with comment 132231
To read all comments associated with this story, please click here.
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 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 Parent Score: 2

RE: Question in my mind....
by frankr on Sun 11th Jun 2006 11:14 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 Parent Score: 1