DOCUMENTATION CENTER SEARCH

New to Mathematica? Find your learning path »

Mathematica > Data Manipulation > Importing and Exporting > DBF (.dbf) >

MATHEMATICA IMPORT/EXPORT FORMAT

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 a subelement.

Import imports multiple elements.

The import format can be specified with Import or Import.

See the reference pages for full general information on Import.

ImportString supports the DBF format.

General Import elements:

	"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.

Import option:

"EmptyField"

""

how empty cells are represented in Mathematica

Importing & Exporting

Importing & Exporting Database Formats

Listing of All Formats

New in 6.0: Import & Export Formats

Basic Examples (1)

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:

Out[1]=

Import data from a DBF file:

Out[2]//TableForm=

Import the column labels as a list of strings:

Out[3]=

Read this file as a list of labeled datasets, giving a rule for each column:

Out[4]=

Ask a question about this page | Suggest an improvement | Leave a message for the team

Format: HTML | CDF