MDB (.mdb)

• Import supports the MDB 2000 format.

• Mathematica can read MDB files without having Microsoft Access installed.

IMPORT

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

OPTIONS

• Import option:

"EmptyField"

""

how empty cells are represented in Mathematica

SEE ALSO

• "CSV"  "DBF"  "DIF"  "Table"  "TSV"  "XLS"

MORE ABOUT

• Date & Time

• Importing & Exporting

• Importing & Exporting Database Formats

• Listing of All Formats

• New in 6.0: Data Handling & Data Sources

• New in 6.0: Import & Export Formats

• Statistics

EXAMPLES

CLOSE ALL

Basic Examples   (1)

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]:= Out[1]= Import the names of all datasets stored in the file: In[2]:= Out[2]= Import the data labels available for this dataset: In[3]:= Out[3]= Import data associated with three labels: In[4]:= Out[4]= Import an entire dataset as a list of rules: In[5]:= Out[5]= Import all data from an MDB database: In[6]:= Out[6]=