How to link a calc spreadsheet to a base database?

English
,
#1

I would like to have a calc spreadsheet that feeds off information/data in a base database. Then when the database is updated, this in turn will update the spreadsheet information after a “refreash”.
Is this possible in libreoffice? if so where is the documentation / howto?

Regards

How to export data from Base?
I have Microsoft Works database. I have just downloaded LibreOffice and want to transfer my database material to its Database. Is it possible to do this, please? Or do I have to re-enter the data bit by bit i.e. start afresh on LibreOffice?
Guidance on creating a form needed (newbie on this subject)
Combine multiple sheets into one master sheet
LO BASE and HSQL DDL
#4

Here you can find a detailed explanation:

Tutorial - Using registered datasources in Calc

201405167 - edited the link

#5

could you post another link because I can’t access this one, please!

#6

Edited, I think there was changes in the openoffice forum url, please try again.

#7

In LibreOffice 6.0.6.2 I had to use Ctrl+Shift+F4, not F4 as the referenced OpenOffice tutorial says as does Data Sources - LibreOffice Help. However, Menu->View Data Sources does work as the latter says.
Thanks!

#2

I think it is from Insert → Link to external data.

Unfortunately 3.6.1.2 appears to have a bug since it stops working when I attempt to do the link

#3

I you are trying to link with Base, this is not the right way, follow the link on my first answer.

#8

Thank you for the tutorial, I see that it works.

#9

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.