Queries
Select from one of the videos below to see how you can extract and format data from one of your systems.
Executing Queries and Other SQL Statements
- 01) Execute Highlighted SQL Statement
- 02) Maintain Connection Profiles / Update Passwords
- 03) Rotate Headings and Auto Width Columns
- 04) Build Example SQL Statements Based on Current Tab’s Data
- 05) (1,2,3) – Changes Data in Place For SQL Where Clauses
- 06) (‘A’,’B’,’C’) – Changes Data in Place For SQL Where Clauses
- 07) Comments Add
- 08) Comments Delete
Extract Data From All Tables
- 09) Create Tabs On Current Workbook Matching Table Names From Selection
- 10) Populate ALL Tables Based on the Current SQL Tab (Works ONLY with Queries 09)
Miscellaneous
- 11) UpDate Pivot Table With Selected SQL
- 12) Remove Data Connections
- 13) Open 64-Bit ODBC Data Source Administrator
- 14) Create INSERT Statement Using Highlight Cells
Queries | Lists | Find | Alter | Clean | Sum | Functions | Help | Misc