Ask Your Question

Adding a column to a LibreOffice database file

asked 2019-02-09 12:28:35 +0100

baxtec gravatar image

I have an existing database with over 1000 entries. I now need to add a further column to the database but I cannot find any way of doing this. I have got round the immediate problem by saving the database as a spreadsheet and manipulating that - but of couse it doesn't give me all the functionality of a database. Is there any way of modifying the database please?

edit retag flag offensive close merge delete



Please specify which database you are using such as HSQLDB embedded, Firebird embedded or otherwise. Also the specific LO version & your OS.

Typically, by just editing the table you can add a new field but it also depends upon the DB and how you may be setting the field.

Ratslinger gravatar imageRatslinger ( 2019-02-09 17:53:47 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-02-09 18:54:47 +0100

baxtec gravatar image

updated 2019-02-09 18:56:13 +0100

Solved. Thanks for the Comment Ratslinger - that gave me a clue and I found that right-clicking on the Table icon and then selecting Edit got me to the Design view where I could add the new field.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-02-09 12:28:35 +0100

Seen: 33 times

Last updated: Feb 09