Database Toolbox

Exporting BOOLEAN Data

This example adds two rows of data to the Products table in the Access Nwind database.

1. In the MATLAB Command Window, create the structure P, which will be exported, by typing these commands:

• P.ProductName{1}='Chocolate Truffles';
  P.Discontinued{1}=logical(0);
  P.ProductName{2}='Guatemalan Coffee';
  P.Discontinued{2}=logical(1);
  

2. For the Data operation, choose Insert.
3. From Data source, select a data source; for this example, SampleDB.
4. From Tables, select a table; for this example, Products.
5. From Fields, select the fields; for this example, ProductName and Discontinued.
6. Assign the MATLAB workspace variable; for this example, use P.
7. Click Execute to run the query.

1. The VQB inserts two new rows into the Products table.

8. View the table in Microsoft Access to ensure the data was correctly inserted.

   

BOOLEAN (MATLAB logical) Data

Using VQB Queries in Database Toolbox Functions

© 1994-2005 The MathWorks, Inc.