Text Documents (Writer)
HTML Documents (Writer Web)
Spreadsheets (Calc)
Presentations (Impress)
Drawings (Draw)
Database Functionality (Base)
Formulae (Math)
Charts and Diagrams
Macros and Scripting
Office Installation
Common Help Topics
OneOffice Logo

Exchange Database

Change the data sources for the current document. To correctly display the contents of inserted fields, the replacement database must contain identical field names.

To access this command...

Choose Edit - Exchange Database

For example, if you inserting address fields in a form letter from an address database, you can then exchange the database with another address database to insert different addresses.

Exchange Databases

You can only change one database at a time in this dialogue box.

Databases in Use

Lists the databases that are currently in use. The current document contains at least one data field from each of the databases in the list.

Available Databases

Lists the databases that are registered in Office.

Browse

Opens a file open dialogue box to select a database file (*.odb). The selected file is added to the Available Databases list.

Define

Replaces the current data source with the data source that you selected in the Available Databases list.

To exchange a database:

Ensure that both databases contain matching field names and field types.

  1. Click in the document that you want to change the data source for.

  2. Choose Edit - Exchange Database.

  3. In the Databases in Use list, select the database table that you want to replace.

  4. In the Available Databases list, select the replacement database table.

  5. Click Define.