Excel VBA Introduction Part 56.3 - Read and Execute SQL Query Files

Download files here https://www.wiseowl.co.uk/vba-macros/... By Andrew Gould https://www.wiseowl.co.uk - In this video you'll learn how to open an SQL Query file, read its contents and use the result to populate an ADO recordset. You'll learn how to use file picker and folder picker dialog boxes to allow the user to pick which queries to run. You'll also learn a little about the Scripting Runtime object library and how to work with FileSystemObjects and TextStreams. If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching! You can buy our Introduction to Excel VBA book here http://www.lulu.com/shop/andrew-gould... Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, VBA, Power BI, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access and more

Join Today
Excel VBA Introduction Part 56.4 - Return Multiple Result Sets from SQL Queries
▶︎

Excel VBA Introduction Part 56.4 - Return Multiple Result Sets from SQL Queries

Excel VBA Introduction Part 23 - Text Files (FileSystemObjects)
▶︎

Excel VBA Introduction Part 23 - Text Files (FileSystemObjects)

Excel VBA Introduction Part 58.5 - SQL for Excel Files - Adding Criteria to a Query
▶︎

Excel VBA Introduction Part 58.5 - SQL for Excel Files - Adding Criteria to a Query

Searches using SQL VBA queries in Excel
▶︎

Searches using SQL VBA queries in Excel

Excel VBA Introduction Part 22 - Files and Folders (FileSystemObjects)
▶︎

Excel VBA Introduction Part 22 - Files and Folders (FileSystemObjects)

Call a SQL Server Stored Procedure using Excel Parameters
▶︎

Call a SQL Server Stored Procedure using Excel Parameters

Excel VBA Introduction Part 56.2 - Get Data from SQL Server with ADO Recordsets
▶︎

Excel VBA Introduction Part 56.2 - Get Data from SQL Server with ADO Recordsets

Excel VBA Introduction Part 5 - Selecting Cells (Range, Cells, Activecell, End, Offset)
▶︎

Excel VBA Introduction Part 5 - Selecting Cells (Range, Cells, Activecell, End, Offset)

Which Tool Handles 40,000 Hotel Bookings Best? | Excel vs Power Query vs SQL vs Python
▶︎

Which Tool Handles 40,000 Hotel Bookings Best? | Excel vs Power Query vs SQL vs Python

Excel VBA Introduction Part 52.1 - Introduction to Shapes
▶︎

Excel VBA Introduction Part 52.1 - Introduction to Shapes

Integrate Excel, VBA and SQL. Simplified and powerful
▶︎

Integrate Excel, VBA and SQL. Simplified and powerful

Run SQL queries in MS Excel
▶︎

Run SQL queries in MS Excel

4 Hours Chopin for Studying, Concentration & Relaxation
▶︎

4 Hours Chopin for Studying, Concentration & Relaxation

Excel VBA Introduction Part 56.7 - Stored Procedures and Parameters with ADO
▶︎

Excel VBA Introduction Part 56.7 - Stored Procedures and Parameters with ADO

Clear Mind Intense Focus | Ambient Techno | ADHD High Focus Support
▶︎

Clear Mind Intense Focus | Ambient Techno | ADHD High Focus Support

Excel VBA Create SQL Query on Worksheet
▶︎

Excel VBA Create SQL Query on Worksheet

SQL Tutorial for Beginners
▶︎

SQL Tutorial for Beginners

Excel VBA Introduction Part 35 - Class Modules
▶︎

Excel VBA Introduction Part 35 - Class Modules

Why AI Agents are either the best or worst thing we’ve ever built
▶︎

Why AI Agents are either the best or worst thing we’ve ever built

SQL Course for Beginners [Full Course]
▶︎

SQL Course for Beginners [Full Course]