Ask Your Question

Is there a bulk load program for Base?

asked 2020-07-25 18:53:01 +0200

gwcarter gravatar image

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?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2020-07-26 19:51:31 +0200

gwcarter gravatar image

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.

edit flag offensive delete link more

answered 2020-07-25 19:13:36 +0200

Ratslinger gravatar image


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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-07-25 18:53:01 +0200

Seen: 37 times

Last updated: Jul 26