Import dBase files (.dbf)

Home | File menu | ImportShow all | About | Parameters | Buttons | Details

About

OxonStat can import dBase file formats and is compatible with FoxPro

Shortcut key

⌥⌘O

Parameters

Options

Missing code

Specify a value to be treated as a missing value code, resulting in an empty cell in OxonStat

All 9s

Some legacy systems use a field value consisting completely of 9s to represent a missing value. This option allows those files to be read into OxonStat skipping the flagged values. So for example a field with a total width of 3 characters and 1 decimal place would use a value of 9.9, while a field with a total width of 5 characters and no decimals 99999.

Text encoding

Select the text encoding used to create the original file. See Text encodings for details.

Preview

As you choose options above the Preview panel updates to show what the first 10 lines of data would look like if you imported the data with those settings.

Buttons

?

Opens the help system for this dialog.

Cancel

Prevents the file from being imported.

Import

Accepts the current choices and proceeds with the import.

Details

For dBase files all the required information is available in the files to read everything into the appropriate column types.