ODBC Tables

This command allows you to import multiple tables from an external data source into multiple worksheets in a single step. This is different from Excel's Get External Data feature in that it lets you bring in all of the data rows from all of the tables you select without needing to know how to query a database. Excel requires you to do this one SQL Query at a time.

The left hand pane lists all of your configured data sources. WHen you click on an item in this list, the center pane will display all of the tables available in the selected data source. Select the items you would like to import by checking them. You can use the Select All button to check all of the items and the Clear button to uncheck all of the items.

Use the Browse button to display the rows of data contained in the currently highlighted table.

The following options are available:

Import To New Workbook

If checked, each table that is imported will be placed into a new worksheet within the currently opened workbook. If not checked, a new workbook will be created.

Import Empty Tables

If checked, a new sheet will be created for a table even if there are no rows of data in that table.

Show Tables

When checked, the center pane will list all tables in the currently selected data source.

Show Queries/Views

When checked, the center pane will also list all queries or views. A query or view is similar to a table but it does not actually contain any data rows. Instead it contains the SQL commands necessary to produce the data rows from other tables, queries or views.

Show System Tables

Most database systems use special tables to manage themselves. These tables are often referred to as system tables. Checking this option lets you see and import these tables. Unless you are analyzing database meta data or security objects, you should not need to use this option.

Create Sheet Index

When checked, Easy-XL will create an index sheet for the workbook after the import is complete.