Advanced Database – Link external data to a database: existing database

To link data from a different database source, open a new LibreOffice Base file.

19 Link external data to a database existing database

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.