Database Toolbox |
 |
Databases
Your system must have access to an installed database. The Database Toolbox supports import/export of data from any ODBC/JDBC-compliant database management system, including the following.
- IBM DB2
- Informix
- Ingres
- Microsoft Access
- Microsoft SQL Server
- Oracle
- Sybase SQL Server
- Sybase SQL Anywhere
If you are upgrading from an earlier version of a database, such as Microsoft SQL Server Version 6.5, to a newer version, there is nothing special you need to do for the Database Toolbox. Just be sure to configure the data sources for the new version of the database application as you did for the original version.
Note
We recommend that you do not include spaces in table and column names. Although Access supports the use of spaces in table and column names, most other databases do not. To retrieve data from tables whose names contain spaces, use delimiters around the table name when building the query. For example, some databases use brackets, [ ]. The Visual Query Builder does not allow spaces in table names.
Also, be sure not to name columns using the database's reserved words, such as DATE in Microsoft Access, or you will not be able to import or export the data using the Database Toolbox. |
| Setup | | Drivers |  |