Progress
Basic Database
Tools


Admin>Import Data

Choose this option to import data with different file formats to the working database. Table 10–10 describes the menu that appears when you choose this option. More detailed descriptions of the options follow the table.

Table 10–10: Import Data Menu 
Import Data

DIF ...

Imports files with DIF format.

SYLK ...

Imports files with SYLK format.

Delimited Text ...

Imports files with text format.

Fixed-Length ...

Imports files in fixed-length file format.

dBASE Definitions ...

Imports dBASE II, III, III+, and IV file structures.

dBASE File Contents ...

Imports files with dBASE format.

Choose Import Data then either the DIF, SYLK, Delimited Text, or dBASE File Contents option to import 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–10 appears.

Figure 10–10: Import DIF Dialog Box

This dialog box contains the following user-interface elements:

Import File

Specifies the load file.

Import

Specifies the fields you want to import. The default value is Some. Each field corresponds to a worksheet column. Each row in the worksheet becomes a record in the table. For each row, Progress loads worksheet values column by column into the specified record fields.

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 import them into your file. To skip a column in the worksheet, do not press RETURN while the field is highlighted. Press GO to import the fields.

Disable Triggers During Import?

Specifies whether to disable triggers during the import.

Text Only: To import a file in delimited text format, you must also specify the field separation character.

dBASE File Contents Only: To import dBASE file contents, you must also specify if the file originated on an IBM PC or compatible.

Import Data Fixed-Length

Choose Import Data Fixed-Length to import data in fixed-length format. When you choose this option, Progress alphabetically lists all the tables defined for your database. When you select a table, the Import Fixed-Length dialog box shown in Figure 10–11 appears.

Figure 10–11: Import Fixed-Length Dialog Box

This dialog box contains the following user-interface elements:

Import File

Specifies the load file.

Disable Triggers During Import?

Specifies whether to disable triggers during the import.

When you choose OK, the Fixed Length Field Columns dialog box shown in Figure 10–12 appears.

Figure 10–12: Fixed Length Field Columns Dialog Box

This dialog box lists the fields you can import. Select the desired fields.

Import Data dBASE Definitions

Choose Import Data dBASE Definitions to import dBASE II, III+, and IV file structures. When you choose this option, the dialog box shown in Figure 10–13 appears.

Figure 10–13: Import dBASE II, III, III+ and IV Definitions Dialog Box

Specify the DBF filename and up to 10 index (NDX) names. If you want to import more than 10 indexes, you must rerun the option and specify the remaining indexes.


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