Fill Calc worksheet with the result of a Base Query

[nickdg1]

I’m trying to extract random value from a ODBC DB filtered with a query in Base.

I think it’s easy if i can get the result of my query in a worksheet automatically.
I found only possibility to import data to setup a Pivot, but it isn’t what i want.

Thanks
Ivan

[Ratslinger]

Hello,

You can easily place query or table data from a Base connection into Calc. This is done using a Registered database (default when creating a Base file). If this wasn’t done, you can register a database any time. See LibreOffice Base Guide Chapter 7 - Linking in Databases.

This documentation also discusses getting data into Calc using the registered database. In Calc from the menu it is View->Data Sources (Shift+Ctrl+F4)