Ellen Art School
Back to Simple DBFTechnical Documentation

Working with Memo Fields

Understand how dBase III handles large text data and how to manage these files within Simple DBF.

What are Memo Fields?

In the dBase III format, standard fields have a fixed character limit (usually 254 characters). Memo fields are used when you need to store much larger amounts of text, such as notes, descriptions, or full documents.

The .DBT Connection

Memo data isn't actually stored inside the .dbf file. It is stored in a companion file with the .dbt extension. Without the matching DBT file, the memo data cannot be read.

Import & Export Workflow

Simple DBF focuses on speed and portability. Currently, memo fields must be handled manually during the conversion process to ensure data integrity.

1

The .DBT Pairing

When importing, ensure your filename.dbt is in the same folder as your filename.dbf. Note that .dbt files usually have the same name as its "parent" .dbf file. Go ahead and open up the DBF file in Simple DBF.

2

Import the DBT File

As already stated, Simple DBF has been designed for speed and portability, and for that reason, it does not automatically import the DBT file. In the spreadsheet editor, click on the button "Extract DBT Memo Fields" and select the DBT file paired with the DBF file. After that, the import should be automatically applied and you can see the memo field data.

3

Editing Memo Fields

To edit data in the memo field, click on the little button to the right-most side of the cell to open up the memo editor. Make the necessary chages, and when you are done, click on "Apply Memo Field to DBT" and select the location you want to save the file to.

4

Export to CSV (Optional)

If you want, you can export the full DBF file to CSV (after importing the DBT as needed). Simple DBF will include all contents in the .dbt file under each CSV column respectively.

Important Constraint

Simple DBF currently supports dBase III memo formats. If your file was created in Visual FoxPro or dBase IV, the memo headers may be incompatible.

Technical Storage

The Pointer System

Inside the .dbf file, the memo field only contains a 10-byte number. This number acts as a "pointer" to a specific block inside the .dbt file.

Block Size

Data is stored in 512-byte blocks. This is why .dbt files often grow quickly in size even if you only add a few sentences of text.