Database Toolbox

Using Functions in the Database Toolbox

When first using the toolbox, follow the simple examples in this section consecutively. Once you are familiar with the process, refer to the example of interest. To run these examples, you need to set up the specified data source--for instructions, see Setting Up a Data Source. If your version of Microsoft Access is different from the one used here, you might get different results. M-files containing functions used in some of these examples are in matlab/toolbox/database/dbdemos. For more information on the functions used in these examples, type doc followed by the function name, or see Function Reference.

Importing Data into MATLAB from a Database	Import data from the `SampleDB` data source, including setting the format for retrieved data.
Viewing Information About the Imported Data	View information retrieved from the `SampleDB` data source, such as number of rows and column names.
Exporting Data from MATLAB to a New Record in a Database	Export a new record from MATLAB and commit it to the `SampleDB` data source.
Replacing Existing Data in a Database from MATLAB	Update an existing record in the `SampleDB` data source.
Exporting Multiple New Records from MATLAB	After importing data from the `dbtoolboxdemo` data source, export multiple records to a different table.
Retrieving BINARY or OTHER Java SQL Data Types	Retrieve `BINARY` or `OTHER` Java SQL data types, such as bitmap images and MAT-files.
Accessing Metadata	Get information about the `dbtoolboxdemo` data source.
Performing Driver Functions	Create driver objects and set and get the properties (does not require you to set up a data source).
About Objects and Methods for the Database Toolbox	Use object-oriented methods with the Database Toolbox.
Working with Cell Arrays in MATLAB	Examples for the toolbox, if you are unfamiliar with cell arrays, used for mixed data types.

Using VQB Queries in Database Toolbox Functions Importing Data into MATLAB from a Database