Ask Your Question

How do I likn a Calc spreadsheet to a Database table

asked 2019-06-05 05:33:42 +0200

pawinda gravatar image

Is there a way to link a spreadsheet to a database table so that changes to the spreadsheet are reflected in the table as they happen?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-06-05 06:37:23 +0200

Ratslinger gravatar image

updated 2019-06-05 06:55:10 +0200


The only method I can visualize where that may be possible is through writing all custom macros (personally would not even attempt).

Currently you can create a Base file where tables are based upon data in a Calc file (Note this is not truly a database). However you will not see any Calc file changes in the tables until Base is re-opened.


For a simple process of Base creation from a Calc file, see -> The simplest way to make databases in The post is old and based on Open Office but this process has not really changed.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-06-05 05:33:42 +0200

Seen: 64 times

Last updated: Jun 05 '19