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

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.
  • Import imports an MDB database, returning a list of arrays.
  • Import 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 imports the specified element from an MDB 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
  • 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 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 element by default.
"EmptyField"""how empty cells are represented in Mathematica
Show the Import elements available in an MDB sample file:
Import the names of all datasets stored in the file:
Import the data labels available for this dataset:
Import data associated with three labels:
Import an entire dataset as a list of rules:
Import all data from an MDB database:
Show the Import elements available in an MDB sample file:
In[1]:=
Click for copyable input
Out[1]=
Import the names of all datasets stored in the file:
In[2]:=
Click for copyable input
Out[2]=
Import the data labels available for this dataset:
In[3]:=
Click for copyable input
Out[3]=
Import data associated with three labels:
In[4]:=
Click for copyable input
Out[4]=
Import an entire dataset as a list of rules:
In[5]:=
Click for copyable input
Out[5]=
Import all data from an MDB database:
In[6]:=
Click for copyable input
Out[6]=