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."
Permalink for comment 132491
To read all comments associated with this story, please click here.
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 Parent Score: 1