Mathematica Import/Export Format

MDB (.mdb)

MIME types: application/mdb, application/msaccess, application/vnd.msaccess
MDB database file.
Native format of the Microsoft Access database application.
Used in conjunction with the Access relational database management system and as an exchange format.
Binary format.
Stores numerical and textual information as sets of tables.
Developed by Microsoft in 1992.

Import supports the MDB 2000 format.

Mathematica can read MDB files without having Microsoft Access installed.

System requirement: Import of MDB files is supported on computers that are capable of running Java 1.5.

IMPORT

Import["file.mdb"] imports an MDB database, returning a list of arrays.

Import["file.mdb"] returns a list of two-dimensional arrays, each representing a database table.

MDB data is represented in Mathematica by real or integer numbers, strings, Boolean values True and False, and DateList specifications.

Import["file.mdb", elem] imports the specified element from an MDB file.

Import["file.mdb", {elem, sub_a, sub_b, ...}] imports a subelement.

Import["file.mdb", {{elem₁, elem₂, ...}}] imports multiple elements.

The import format can be specified with Import["file", "MDB"] or Import["file", {"MDB", elem, ...}].

See the reference pages for full general information on Import.

ImportString supports the MDB format.

ELEMENTS

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

Specifying and selecting datasets:

	"Data"	all datasets given as a list of arrays
	"Datasets"	names of all datasets
	"Datasets", n	the n dataset given as an array
	"Datasets", name	dataset name name given as an array
	"Datasets", name, "Labels"	list of strings, representing the column labels of dataset name
	"Datasets", name, "LabeledData"	dataset name using rules for each column