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

Run SaveToDB, Wizards, Data Connection Wizard

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

Select Microsoft OLE DB Provider for SQL Server

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

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

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

Select xls23.view_query_list_form in the Query List

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

Select parameter values

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

A dialog box to choose a cell to insert a table

Select cell B3 in the worksheet:

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.

An initial form with empty parameters

Increase the window width to see the complete ribbon:

Complete SaveToDB 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:

Open SaveToDB Options and select the desired language

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

You will see the translated parameter names:

SaveToDB ribbon with translated parameters

Select parameter values and voilá!

Planning application Excel form

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.OK