Data Retrieval Restrictions
Spaces in Table Names or Column Names
Microsoft Access supports the use of spaces in table and
column names, but most other databases do not. Queries that retrieve
data from tables and fields whose names contain spaces require delimiters
around table names and field names. In Access™, enclose the table
names or field names in quotation marks, for example, "order
id". Other databases use different delimiters, such as brackets,
[ ]. In Visual Query Builder, table names and field names that include
spaces appear in quotation marks.
Back to Top
Quotation Marks in Table Names or Column Names
Do not include quotation marks in table names or column names.
The Database Toolbox software does not support data retrieval
from table and column names that contain quotation marks.
Back to Top
Reserved Words in Column Names
You cannot use the Database Toolbox software to import or
export data in columns whose names contain database reserved words,
such as DATE or TABLE.
Back to Top
 | Supported Data Types | | Working with Data Sources |  |
Includes the most popular MATLAB recorded presentations with Q&A sessions led by MATLAB experts.
Get the Interactive Kit
Store 
