Ask Your Question
0

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
0

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

Ratslinger gravatar image

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

Hello,

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.

Edit:

For a simple process of Base creation from a Calc file, see -> The simplest way to make databases in OpenOffice.org. 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

Stats

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

Seen: 27 times

Last updated: Jun 05