Working with WHERE Fields
Today we discuss how to load into Excel the required database data only.
In the previous step, we have connected to a database.
You can 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 of the first column define columns to select.
Checkboxes of 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:
I hope you will like this feature.
In the next letters, we will discuss several useful features for working with web data.
CEO | Gartle LLC