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, [ ].
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.
You cannot use the Database
Toolbox software to import or export data in columns whose names contain
database reserved words, such as