Database Toolbox

Visual Query Builder

The Visual Query Builder is a graphical user interface (GUI) for exchanging data between a database and MATLAB.

Getting Started with the Visual Query Builder GUI	Follow the list of steps to use the Visual Query Builder (VQB) for importing and exporting data. Know when to use the VQB tool and when to use toolbox functions.
Creating and Running a Query to Import Data	Build and run a query to import data.
Saving, Editing, Clearing Variables for, and Specifying Preferences for Queries	Save a query for later use, edit a query, clear variables in the Data area, and set preferences for data retrieval format, `NULL`s, and errors.
Viewing Query Results	View results as a relational display, a chart, in a table report, and in a customized report.
Fine-Tuning Queries Using Advanced Query Options	Retrieve unique occurrences, retrieve data meeting specified criteria, order the results, use subqueries to retrieve values from multiple tables, and other options.
Retrieving BINARY and OTHER Java Data	Retrieve Java object data, such as binary images.
Exporting Data Using the VQB	Export data from MATLAB into new rows in a database.
BOOLEAN (MATLAB logical) Data	Import and export BOOLEAN (MATLAB `logical`) data.
Using VQB Queries in Database Toolbox Functions	After running queries using the VQB, copy information from the VQB and paste it into Database Toolbox functions in the MATLAB Command Window.

Online Help Getting Started with the Visual Query Builder GUI