Progress
Basic Database
Tools


Admin>Export Data

Choose this option to export data in different formats. Table 10–8 describes the menu that appears when you choose this option. More detailed descriptions of the options follow the table.

Table 10–8: Export Data Menu
Export Data

DIF ...

Exports data records in DIF format.

SYLK ...

Exports data records in SYLK format.

Text ...

Exports data records in plain text format.

WordStar Merge Data...

Exports data records to WordStar in text format.

Microsoft Word Merge Data...

Exports data records to Microsoft Word in text format.

WordPerfect Merge Data...

Exports data records to WordPerfect in text format.

Choose these options to export data in the specified format. When you choose the desired format, Progress alphabetically lists all the tables defined for your database. When you select a table, a dialog box similar to the one shown in Figure 10–8 opens.

Figure 10–8: Export DIF Dialog Box

This dialog box contains the following user-interface elements:

Output File

Specifies the name of the destination file. Table 10–9 lists the export format file extensions.

Table 10–9: Export Format File Extensions 
File Format
Extension
DIF
.dif
SYLK
.sl
Text
.txt
WordStar
.txt
Microsoft Word
.doc
WordPerfect
.txt

WHERE-Clause

Specifies the record selection criteria (for example, WHERE cost > 100). A record becomes a row in a worksheet, and the worksheet starting point is always row 1, column 1. The default is to select all the records.

BY-Clause

Specifies that you want to sort the records using a BY clause (for example, BY name). The default is to use the primary index.

Export Fields

Specifies the fields you want to export. The default value is Some. Each field corresponds to a worksheet column.

If you specify Selected Fields, Progress lists all the fields in the specified file. To select a field, press SPACEBAR to highlight the field, than press RETURN. Select the fields in the order you want to export them into your destination file. To skip a column in the worksheet, do not press RETURN while the field is highlighted. Press GO to export the fields.

Disable Triggers During Export?

Specifies whether to disable triggers during the export.

Text Only: After you enter the data into the Export Data dialog box, the Output Record Formatting dialog box shown in Figure 10–9 appears.

Figure 10–9: Output Record Formatting Dialog Box

This dialog box contains the following user-interface elements:

Record Starter String

Specifies the character that indicates the beginning of a record. Enter the appropriate three-digit code.

Record End String

Specifies the character that indicates the end of a record. The default is a carriage return (~012).

Field Delimiter

Specifies the character that surrounds a field. The default is a quotation mark (").

Field Separator

Specifies the character that separates fields. The default is a comma (,).

NOTE: Do not use a Progress escape character—tilde (~) or backslash (\)—as a field delimiter or field separator.

For all formats, Progress informs you of the number of records it dumped in specified format and prompts you to continue.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095