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, go directly 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 than 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. As you work with the examples, you can open the M-files to see the functions and copy them, or you can run the M-files to see the results. 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 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.
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	Simple examples for the toolbox, if you are unfamiliar with MATLAB cell arrays, used for mixed data types.

Other Features in Advanced Query Options Importing Data into MATLAB from a Database