Insert Base query results into Calc

[mrgou]

I created a Base database file and registered it. It successfully pulls data from a MySQL server. I can create and run queries as expected.

Next, I’d like to push the results of a query into a Calc spreadsheet for further processing, such as graphs. So I create a new spreadsheet, and in the Sheet menu, select Link to External Data, and in the dialog, I browse to open my odb file.

However, the Tables/ranges box underneath indicates that no named range is available in the selected document.

What am I missing?

Thanks!

[Ratslinger]

Hello,

Data for registered databases is accessed through Data Sources (View->Data Sources).

From there you can select the Query then drag the data to the sheet. Then you will have a named range.

[mrgou]

Ah, that’s it, thanks!