Advanced Database – Link external data to a database: existing database
To link data from a different database source, open a new LibreOffice Base file.
In step 1 of the wizard, choose ‘Connect to an existing database’ and select the format of the database e.g. Microsoft Access 2007.
Click Next and then select a database file.
Finish and save. The database will then import data from that database and any changes will automatically update.
Import spreadsheet, text (.txt, .csv), XML into a database.
There is no automatic way to import data from a spreadsheet or document into Base.
You must simply copy and paste the values into a table.
This method is outlined in full in the Using Databases module.