OpenOffice.org OpenOffice - 3.2 Guía de inicio rápido descargar pdf (Pagina 284)

Accessing other data sources

OpenOffice.org allows data sources to be accessed and then linked into

OOo documents. For example, a mail merge links an external document

containing a list of names and addresses into a letter, with one copy of

the letter being generated for each entry.

To access a data source that is not a *.odb file:

1) File > New > Database opens the Database Wizard window.

2) Select Connect to an existing database. Click the arrow next to

the Database type field and select the database type from the

dropdown list. Click Next.

3) Click Browse and select the database. Click Next.

4) Accept the default settings: Register the database for me, and

Open the database for editing. Click Finish. Name and save the

database in the location of your choice.

Accessing a spreadsheet as a data source

Accessing a spreadsheet is similar to accessing other databases:

1) Choose File > New > Database.

2) Select Connect to an existing database. Select Spreadsheet as the

Database type.

3) Click Browse to locate the spreadsheet you want to access. If the

spreadsheet is password protected, check the Password required

box. Click Next.

4) If the spreadsheet requires a user’s name, enter it. If a password

is also required, check its box. Click Next.

Note

Using this method of accessing a spreadsheet, you cannot

change anything in the spreadsheet. You can only view the

contents of the spreadsheet, run queries, and create reports

based upon the data already entered into the spreadsheet.

All changes in a spreadsheet must be made in the spreadsheet

itself, using Calc. After modifying the spreadsheet and saving it,

you will see the changes in the database. If you create and save

an additional sheet in your spreadsheet, the database will have

a new table the next time you access it.

284 Getting Started with OpenOffice.org 3.x

Free eBook Edition

1 2 ... 279 280 281 282 283 284 285 286 287 288 289 ... 441 442

OpenOffice.org OpenOffice - 3.2 Guía de inicio rápido Pagina 284