Database Toolbox™

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, [ ]. In Visual Query Builder, table names and field names that include spaces appear in quotation marks.

Back to Top

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.

Back to Top

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.

Back to Top

Supported Data Types

Working with Data Sources