Main Content

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