Introduction
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

Insert Database Columns

Inserts all fields of the marked record into the current document at the cursor position. The icon is only visible if the current document is a text document or a spreadsheet.

Data to Text

In the data source browser, select the record that you want to insert into the document and then click the Data to Text icon. The record is inserted in the document at the cursor position, with the contents of each individual field of the record copied to a table column. You can also select multiple records and transfer them into the document by clicking the Data to Text icon. Each individual record is then written to a new row.

In the data source browser, select the records that you want to insert into the document and then click the Data to Text icon, or drag-and-drop data from the data source browser into the document. This opens the Insert Database Columns dialogue box. Select whether the data should be inserted as a table, as fields or as text.

The preferences you set in the Insert Database Columns dialogue box are saved and will be active the next time that the dialogue box is called. This save process is independent of the database and can record the preferences for a maximum of 5 databases.

If data is inserted into the document as a table, the table properties are not saved along with the data in the document. If you select the AutoFormat function for formatting the table, Office will note the name of the format template. This template will then be used automatically if you insert data as a table again, unless the preferences have been changed.