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.
- Open your database .odb file.
- Click the Tables icon.
- Right-click on the name of the table to export. Choose Copy.
- Go to a spreadsheet. Paste.
The data will appear.