I need to add lists of people and characteristics to multiple tables in a Base db. I can find no documentation of such a program. Does one exist, or must I write one?
Hello,
Generally, data can be copied from Calc into tables - existing or to be created. If you have vast amounts of data, you are probably not going to be using the embedded databases with Base but rather a server such as MySQL, PostgreSQL, etc. Most of these servers have utilities which allow input from various sources. There are also independent programs such as SQL Workbench/J which has some transfer capabilities.
This is some information in the Base Documentation → LibreOffice Base Guide. See Chapter 3 - section titled Importing data from other sources.
Thank you, Ratslinger. I combined your answer with an answer to another question in this forum to come up with a solution to my problem. Base is not a database. It is a front end to relational databases. I will link to MySQL as a manager, where I can also write my own programs. Thanks again.