Hi there. I’m seeking to work with base. I want to link two calc spreadsheets. One is successfully set up as a table in the base table window. However I don’t seem to be able to add the second table. I can’t find a way of selecting the second spreadsheet to be able to be added in the tables window. Thanks for any help with this.
You can not link spreadsheets because a spreadsheet is not a database.
Your approach is not possible with Base. If you wish to convert your Spreadsheets in a relational Database, you have to create a new empty database (default is HSQLDB embedded)
.
Then you can either define Tables to your needs and Import the data from the spreadsheet afterwards or you may try to mark all data in a spreadsheet table and copy/paste this to the tables section of Base and see if the assistant will get this right…
.
I’ve always prepared my tables manually (or cheated and used SQL). Be prepared for trouble. A database is usually restrictive: It is not allowed to have more than one datatype per column. As spreadsheets are free here a lot of them can not be imported without error.
.
Databases need an unique column als Id, so you have to check, if you have one, need to create one or not. Without a key/Id a database will not allow your tables to be modified (you can not enter data).
In your aporoach the complete spreadsheet-file IS your database, and the sheets would be tables. A second spreadsheet-file is another database, not another table.
.
An intermediate approach can be to use dBase-Tables or even csv files, but I would only recommend, when you often get new Tables from external sources. But it reduces the possibilities of the simulated database…