Articles
Every article Ever Garden has grown, newest first. Narrow them down by topic, tag or a search.
VBA | DB Operations – Part 4: Running MERGE from Excel
Excel macro Part 4: [Running MERGE from Excel]
#excel-vba#oracle#sqlVBA | DB Operations - Part 3: Running INSERT, UPDATE, DELETE from Excel
Excel macro Part 3: [Running INSERT, UPDATE, DELETE from Excel]
#excel-vba#oracle#sqlVBA | DB Operations - Part 2: Storing SELECT Results in Excel
Excel macro Part 2: [Storing SELECT results in Excel]
#excel-vba#oracle#sqlPower Query | How to Load Dynamic SQL Results (Power BI)
I'll explain how to dynamically execute SQL by linking SQL query conditions (e.g., within the WHERE clause) with Power Query parameters.
#power-query#power-bi#sql