ODBC Data source
ODBC is an older standard then OLE DB. It is recommended to use a different data source type unless other data base drivers are not available.
You can access any ODBC data source by selecting ODBC as the data source type and specifying a valid connection string.
Connection string
Specify an ODBC connection string used to identify an ODBC data source.
A typical connection string is:
dsn=<the data source name>Defining ODBC data sources
ODBC data sources can be defined through a Windows Control Panel (Control Panel > Administrative Tools > Data Sources (ODBC)).
Refer to Windows help for more information on how to do this.
Join multiple tables
Most data sources are organized as tables. You can select data from multiple tables at once using this by selecting the option Join multiple tables and selecting the appropriate tables from the drop down list, as seen below:
For each selected table you must specify the name of the table and the ID column.
The ID column is used to match rows in all tables.
Specify SQL statement
If you select Specify SQL statement as the query method you can specify custom queries. See SQL Quick Reference for a quick SQL reference and links to resources.