MDB (.mdb)

  • Import supports the MDB 2000 format.
  • The Wolfram Language can read MDB files without having Microsoft Access installed.

BackgroundBackground

    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 and ExportImport and Export

  • 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 the Wolfram Language 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.
  • ImportString supports the MDB format.

ElementsElements

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

OptionsOptions

  • Import option:
  • "EmptyField"""how empty cells are represented in the Wolfram Language

ExamplesExamplesopen allclose all

Basic Examples  (1)Basic Examples  (1)

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]=
Introduced in 2007
(6.0)