Hi, I was wondering if there is any way one can take a LibreOffice calc spreadsheet and export/transform it into a LibreOffice Database? I have a LibreOffice database with lots of great information, and I would like to take the LibreOffice calc spreadsheet that has been created and basically let the original database absorb and change it (to match). Is this possible? Can the data from the Calc spreadsheet be converted into the LibreOffice database?
Please take a look in the help for “Importing and Exporting Data in Base”
Also you can find more information about base here:
https://wiki.documentfoundation.org/Documentation/Publications
https://wiki.documentfoundation.org/images/9/97/GS4008-GettingStartedWithBase.odt
Accessing a spreadsheet as a data source, page 26.