Ellen Art School
Core Concept

Understanding the DBF Format

The .dbf file extension represents a database file used by dBase, one of the most successful database management systems of the 1980s.

A Brief History

Released originally for CP/M and later MS-DOS, the DBF format became a standard for data storage. Its simplicity allowed it to persist for decades, and it remains the primary way data is exchanged in sectors like GIS (Geographic Information Systems) and legacy inventory management.

File Anatomy

A DBF file is essentially split into two main parts:

  • The Header: Contains metadata like the date of last update, the number of records, and the structure of the columns.
  • The Records: The actual data rows. Each record is a fixed length, making it very fast to "seek" or find a specific row.

What it Primarily Stores

A DBF file, in short, stores a database table.

Characteristics of DBF Files

Types of Fields

There are a few different DBF file versions (also known as dBase levels), and depending on which one the DBF file has, different field types and structures are supported. In general, dBase III files support:

  • Character: Any text can be stored here. A maximum of up to 254 characters is allowed.
  • Date: A date that stores the month, day, and year.
  • Logic: A single character value that represents a boolean. This could be "T" (true), "F" (false), or "?" if uninitialized.
  • Numeric: Any number. As weird as it might sound, there is also a special "character limit" to how this is stored. Characters in this field refer to the decimal point, the sign, and numbers.
  • Memo: Stores long text (no specific character limit set). Note that memo fields are actually stored in a separate DBT file, where in the DBF file, only a pointer to where the text is stored in the DBT file is written.

Ready to work with these files?

Learn about Memo Fields