Ribbon Query List

Ribbon Query List

Example of a query list

The query list allows changing underlying database objects of Excel data tables.

This is the simplest way to connect to a new database object.

This feature allows having fewer worksheets in a workbook.

Also, new database objects come available in Excel immediately after reloading the query list without any additional work.

The SaveToDB add-in contains the default query list that shows all database objects available to connect.

Also, you can use database schemas as query lists.

Database developers can configure query list to show objects by business areas.

You link Excel tables and query lists using Connection Wizard.

You can quickly change it using the query list group dialog box launcher.

Query List Translation

By default, the query list displays native database object names as shown above.

Database developers can configure data translation.

In this case, the query list displays translated object names:

Example of a translated query list

Just can select Data Language in the Options dialog box.

Query Group Elements

Example of the SaveToDB ribbon

Query
The list displays the database object of the active table and allows changing it.
The field is disabled if the Enable the ribbon query list option in the Connection Wizard is turned off.
Reload Query List
The button reloads query list objects, configuration, and data translation.
The field is disabled if the Enable the ribbon query list option in the Connection Wizard is turned off.
Dialog Box Launcher
The query group dialog box launcher displays the Connection Wizard that allows users to change the query list object, to select a new database object, and to configure the Enable the ribbon query list option.

Example of the translated SaveToDB Configure Query form