User`s guide

1 Before You Begin
1-8
Data Retrieval Restrictions
In this section...
“Spaces in Table Names or Column Names” on page 1-8
“Quotation Marks in Table Names or Column Names” on page 1-8
“Reserved Words in Column Names” on page 1-8
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.
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.