Ask Your Question

How can I output a Base query? [closed]

asked 2012-03-23 22:00:59 +0200

anonymous user


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.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-18 17:16:29.096001

2 Answers

Sort by » oldest newest most voted

answered 2012-03-24 00:22:32 +0200

m.a.riosv gravatar image

In this link of OOo forum, there is help about get the data in the spreadsheet:

edit flag offensive delete link more


Thank you!

Elizabeth gravatar imageElizabeth ( 2012-03-24 00:51:10 +0200 )edit

answered 2014-01-18 19:50:28 +0200

Alex Thurgood gravatar image

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. 4) 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.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2012-03-23 22:00:59 +0200

Seen: 6,128 times

Last updated: Jan 18 '14