How can I output a Base query?

[Elizabeth1]

Have several tables created and queries generated. Now I’d like to be able to print them, or output to a text or spreadsheet, but I don’t see an optin to even Save As.

[mariosv]

In this link of OOo forum, there is help about get the data in the spreadsheet:
http://user.services.openoffice.org/en/forum/viewtopic.php?f=75&t=18511

[Elizabeth1]

Thank you!

[iplaw67]

To spreadsheet :

1. Open a new Calc document
2. Open your ODB file.
3. Select one of the tables you want to copy with the mouse (if you want the whole table)
4. Drag the table from your ODB and drop it on the Calc document

Alternatively:

1. Start with steps 1 and 2 as above
2. Open one of your tables (double-click)
3. Select the tuples (rows) of data you want to copy.
4. Keeping the mouse button pressed down, drag and drop to your Calc document.

Both of these methods should work with Query objects too.

With Word Processor:

1. Open a Writer document
2. Press F4 to open the Datasource navigator.
3. In the left-hand side tree pane of available datasources, select the table or query you want.
4. Drag the table you have selected to your Writer document.
5. This will start the wizard which allows you to choose how you want to insert the data (Table, Fields, or Text) and which fields you want to include from the Table or Query.