Today we discuss how to load into Excel the required database data only.

In the previous step, we have connected to a database.

You may use your file or download and open the following workbook

https://www.savetodb.com/downloads/example_of_payments.xlsx (23 KB)

It looks like this:

Click the Reload menu, then the Configure Parameters... button.

You will see the following dialog box:

Checkboxes in the first column define columns to select.

Checkboxes in the last column define columns used to filter data.

Check Account Name, Company Name, and Item Name in the last column and click OK.

The add-in will place the fields on the ribbon.

Open, for example, the Item Name parameter and select Revenue:

The add-in will add WHERE ItemName = 'Revenue' to the SQL query and reload the data:

Hope you will like this feature.

In the next letters, we will discuss several useful features for working with web data.

Best regards,

Sergey Vaselenko
CEO | Gartle Technology Corporation

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.