Data Retrieval Restrictions
Spaces in Table Names or Column Names
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
"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