Ribbon Query List

Ribbon 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 may use database schemas as query lists.

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

You link Excel tables and query lists using Connection Wizard.

You may 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:

Just can select Data Language in the Options dialog box.

Query Group Elements

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.
This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.