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?
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.