This is documentation for Mathematica 6, which was
based on an earlier version of the Wolfram Language.
View current documentation (Version 11.2)
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["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, suba, subb, ...}] imports a subelement.
  • Import["file.mdb", {{elem1, elem2, ...}}] 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.
"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", nthe n^(th) dataset given as an array
"Datasets", namedataset 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
  • Import uses the "Data" element by default.
"EmptyField"""how empty cells are represented in Mathematica