Database Toolbox

Databases

Your system must have access to an installed database. The Database Toolbox supports the import and export of data from any ODBC/JDBC-compliant database management system, including the following:

• IBM DB2
• Informix
• Ingres
• Microsoft Access
• Microsoft Excel
• Microsoft SQL Server
• MySQL
• Oracle
• Postgre
• Sybase SQL Server
• Sybase SQL Anywhere

RDBMS for VAX/VMS systems is not supported.

If you are upgrading from an earlier version of a database, such as Microsoft SQL Server Version 6.5, to a newer version, there is nothing special you need to do for the Database Toolbox. Just be sure to configure the data sources for the new version of the database application as you did for the original version.

Data Retrieval Restrictions

Spaces in Table and Column Names.   Microsoft Access supports the use of spaces in table and column names, but most other databases do not. When using functions to retrieve data from tables and fields whose names contain spaces, use delimiters around the table and field names when building the query. For Access, enclose the table or field name in quotation marks, for example "order id". Other databases use different delimiters, for example brackets, [ ], instead of quotation marks. In the Visual Query Builder, table and field names that include spaces appear in quotation marks.

Quotation Marks in Table and Column Names.   Do not include quotation marks in table and column names. The Database Toolbox does not support data retrieval from table and column names that contain quotation marks.

Reserved Words in Column Names.   Be sure not to name columns using the database's reserved words, such as DATE in Microsoft Access, or you will not be able to import or export the data using the Database Toolbox. You will get an error message in the Command Window, for example, reporting a syntax error from Microsoft Access.

System Requirements

Drivers

© 1994-2005 The MathWorks, Inc.