Using OpenOffice to connect to MySQL and PostgreSQL Databases

[mandy]

OpenOffice.org is one of the premier office suites available on Linux. It has a lot going for it: word processing, spreadsheets, presentations, and more. It also can connect you to any kind of database that you like, including MySQL, PostgreSQL, and others.

Depending on how you installed OpenOffice.org and what your vendor provides, you may have the capability to connect to a MySQL database already. If not, you can easily download the JDBC driver to use Java (which requires installing a JRE) to connect OpenOffice.org to your database. In fact, using the JDBC drivers is perhaps the easiest way to connect to a MySQL database from OpenOffice.org...

With either the JDBC driver or the ODBC drivers installed and ready, you can initiate a connection to a MySQL database. In OpenOffice.org, select File | New | Database. In the Database Wizard, select Connect To An Existing Database and choose MySQL from the drop-down menu; then click Next. Select which method you will be using to connect (ODBC or JDBC) and then click Next again...

full article: http://www.builderau.com.au/program/linu...266,00.htm

a related article:

One of the good things about OpenOffice.org is its ability to use different database engines. Just give it the right driver, and OpenOffice.org can connect to virtually any database system, including MySQL. However, deciding what database driver to use and configuring a connection between MySQL and OpenOffice.org can be a bit tricky. Let's walk through the process...

full article: http://www.linux.com/article.pl?sid=07/02/12/1736203