"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."

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.