Documentation/OOoAuthors User Manual/Writer Guide/Registering a data source

From Apache OpenOffice Wiki
< Documentation‎ | OOoAuthors User Manual‎ | Writer Guide
Revision as of 19:15, 18 September 2009 by Nnino (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search



Registering a data source

Before any OOo documents can use a data source, it must first be registered as described below.

To register a data source:

  1. Click File > Wizards > Address Data Source.
  2. Starting the Address Data Source wizard
    Starting the Address Data Source wizard.

  3. Select the appropriate type of external address book (in this case, Other external data source). Click Next.
  4. Select type of external address book
    Select type of external address book.

  5. On the next page of the Wizard, click Settings.
  6. Starting the Settings part of the Wizard
    Starting the Settings part of the Wizard.

  7. In the Data Source Properties dialog, select the Database type (in this case, Spreadsheet). Click Next.
  8. Selecting the database type
    Selecting the database type.

  9. In the next dialog, click Browse and navigate to the spreadsheet that contains the address information. Select the spreadsheet and click Open to return to this dialog. At this time you may wish to test that the connection has been correctly established by clicking on the Test Connection button.
  10. Selecting the spreadsheet document
    Selecting the spreadsheet document.

  11. Click Finish.
  12. On the following dialog, click Next. (Do not click Field Assignment.)
  13. Do not click Field Assignment
    Because this is a spreadsheet, do not click Field Assignment.

  14. Name the file in the Location field. The default is ...\Addresses.odb, but you may replace Addresses with another name if you wish. You may also change the name in the Address book name field. In our example, the name "Points" was used for both.
  15. Name the file and the address book
    Name the .odb file and the address book.

  16. Click Finish. The data source is now registered.
Content on this page is licensed under the Creative Common Attribution 3.0 license (CC-BY).
Personal tools