To connect to the application, run SaveToDB, Wizards, Data Connection Wizard:

Select Microsoft OLE DB Provider for SQL Server and click Next:

Fill-in the server name, your username and password, and select a database. Click Next.

Select xls23.view_query_list_form in the Query List and leave all check-boxes checked. Click Finish.

You may select parameter values here. Or just click OK.

You will see a dialog box to choose a cell to insert a table.

Select cell B3 in the worksheet:

When you insert a table into cell B3, you have the following benefits:

  1. You may use row 1 to place formulas and comments.
  2. You may use row 2 to filter rows using auto-filters. Just type filter values like >10000 or *CC11*.
    Delete the cell value to clear the auto-filter.
  3. You have an empty column A. The table looks better.

The wizard inserts a table, with empty data columns if you do not specify the parameter values.

Increase the window width to see the complete ribbon:

You see parameter names used in a database if you do not turn on the translation.

To turn on the translation, open SaveToDB Options and select the desired language:

Click OK. Then click Reload, Reload Data and Configuration.

You will see the translated parameter names:

Select parameter values and voilá!

You may edit highlighted cells.

You may paste formulas into form cells. However, the application replaces them with values while reloading data.

Place your formulas under the table. In this case, you may copy and paste values if the source data changed.

You may use Undo (Ctrl-Z) to undo changes.

Use Reload to reload data with newly calculated aggregates.

You may select new parameter values using the ribbon.

You may change forms using the Active Query drop-down list.

Use Reload Query List to reload the list and get new forms configured in a database.

You may copy worksheets. Just copy the worksheet and click Reload, Reload Data and Configuration.

Use Reload, Reload All Workbook Tables to reload all tables at once.

Sometimes, you may see incorrect column orders because of Excel adds new columns at the end.

Just select an empty value in any parameter to clear columns and then select the desired value.

You may change the default table formatting. Use regular and conditional formatting Excel features.

You may restore the default formatting from a database using Wizards, Table Format Wizard.

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.