Calc Guide

Linking to registered data sources
You can access a variety of databases and other data sources and link
them into Calc documents.
First you need to register the data source with OpenOffice.org. (To
register means to tell OOo what type of data source it is and where the
file is located.) The way to do this depends on whether or not the data
source is a database in *.odb format.
To register a data source that is in *.odb format:
1) Choose Tools > Options > OpenOffice.org Base > Databases.
2) Click the New button (below the list of registered databases) to
open the Create Database Link dialog (Figure 260).
Figure 260: Registering databases
3) Enter the location of the database file, or click Browse to open a
file browser and select the database file.
4) Type a name to use as the registered name for the database and
click OK. The database is added to the list of registered
databases. The OK button is enabled only when both fields are
filled in.
To register a data source that is not in *.odb format:
1) Choose File > New > Database to open the Database Wizard.
2) Select Connect to an existing database. The choices for
database type depend on your operating system. For example,
312 OpenOffice.org 3.x Calc Guide