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.
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 |