This is machine translation

Translated by Microsoft
Mouseover text to see original. Click the button below to return to the English version of the page.

Note: This page has been translated by MathWorks. Click here to see
To view all translated materials including this page, select Country from the country navigator on the bottom of this page.

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, [ ].

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.

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.

Related Topics