ODBC Driver Category

Current driver status: Import available, export available.

Drag and drop supported?Yes

Support status: Supported.

To access this driver:

1. Display the Data Import screen. This screen is displayed when import-loading and when adding a file association to the current project. In all cases, functions are found on the Data ribbon.

2. Select the ODBCData Category and an option in the Data Type list.

ODBC (Open Database Connectivity) is a Windows standard for importing and exporting SQL data tables. Databases and spreadsheets which support ODBC can be accessed with these drivers. Each compliant program is supplied with an ODBC driver.

To connect two programs using ODBC, both must support ODBC. You can use ODBC drivers to connect to SQL databases, like Oracle, Access or Excel, and import the data in these databases. Before you can import from a database you must install the appropriate ODBC Driver for this type of database, and set up an ODBC Data Source for the data.

Note: For more information on dialogs, click Help or F1.

Related Information and Activities

• ODBC Data Sources

• ODBC - Supported Data Types

• Apply Advanced ODBC Import Settings

• Specify Block Model Import Settings

• Filtering

• Define ODBC Table Import Settings

• Import ODBC Point Data

• Import ODBC Polygon Data

• Import ODBC String Data

• Select Data Source