This is documentation for Mathematica 8, which was
based on an earlier version of the Wolfram Language.
View current documentation (Version 11.2)

DBF (.dbf)

MIME types: application/dbf, application/dbase
dBASE DBF data files.
Legacy file format for storing and exchanging structured data.
ASCII format.
Native format of the dBASE database management application.
Stores numerical datasets in a portable format.
dBASE IV was introduced in 1988.
  • Import fully supports the DBF format Version 4 and later.
  • Import imports a DBF file, returning all datasets arranged as a table.
  • Import returns a table, with each column representing a dataset.
  • DBF data is represented in Mathematica by real or integer numbers, strings, Boolean values True and False, and DateList specifications.
  • Import imports the specified element from a DBF file.
  • Import imports multiple elements.
  • See the reference pages for full general information on Import.
"Elements"list of elements and options available in this file
"Rules"full list of rules for each element and option
"Options"list of rules for options, properties, and settings
  • Data representation elements:
"Data"datasets arranged as a table
"LabeledData"datasets given as a list of rules
  • Import uses the element by default.
  • Import reads all datasets and returns them as a table.
  • Import imports the entire file and returns an expression of the form , where the are the table headings.
  • Meta-information elements:
"Labels"dataset names given as a list of strings
  • The DBF format can store labels of length 10 or shorter.
"EmptyField"""how empty cells are represented in Mathematica
Get the list of available Import formats:
Import data from a DBF file:
Import the column labels as a list of strings:
Read this file as a list of labeled datasets, giving a rule for each column:
Get the list of available Import formats:
In[1]:=
Click for copyable input
Out[1]=
Import data from a DBF file:
In[2]:=
Click for copyable input
Out[2]//TableForm=
Import the column labels as a list of strings:
In[3]:=
Click for copyable input
Out[3]=
Read this file as a list of labeled datasets, giving a rule for each column:
In[4]:=
Click for copyable input
Out[4]=