One Way to Export Data From OpenOffice Base to a Spreadsheet

In OpenOffice.org 2.2 you can now export data in a reasonable manner. Here's one way in 2.4.

Here's another way you might try. It's almost identical to the (albeit invisible) import method.

1. Open your database .odb file.
2. Click the Tables icon.
3. Right-click on the name of the table to export. Choose Copy.
4. Go to a spreadsheet. Paste.

The data will appear.

---

Comments

[Keet Bugrows]

When I try this my column headers all end up in alphabetical order but the columns stay in the same place, effectively screwing up the spreadsheet.

Keet

[Dave]

This system works well with smaller tables, but when trying to get a nasty imported mdb into a spreadsheet to then export into mysql, it seems to have frozen completely. There are 18 thousand records, so its probably best to use with discretion.

[iain goldmann]

this has been fantastically useful.

One other question: is there a way to get a query result data out of open office base, either through making a table from a query or otherwise?

[Solveig]

Hi Iain,

It should work; just click the Queries icon at the left side of the window, then copy the query you want instead of a table.

Solveig

[Jared Starkey]

HAH! This is to simple and elegant - I love Open Office!