How to Make A Table In OpenOffice or LibreOffice

In this tutorial I will explain how to create a table in LibreOffice base, a free database application that is available on windows mac and linux.

This simple table could be used as a generic table for importing data into your database.

Further queries in the database could then transfer data from this table to other parts of the database while changing datatypes and normalising the data.

This is actually the first step in a small data analysis project for my own use.

I will be creating further tables and automated routines to cleanse the imported data downstream of this import.

For now this tutorial shows you how to create the HSQLDB (LibreOffice base) table and make adjustments to it in SQL.

It also covers some tips and traps that you need to avoid when using Base tables.

Don’t forget to comment below and let me know if this was helpful.

Also feel free to tell me what topics you would like covered in the future.