Excel VBA writing SQL Course

Created by:

WiseOwlTutorials

46 Lessons
184 Students
Certificate of completion

Track:

Computer Science

Excel VBA writing SQL, in this course teaches you how to connect Excel to databases and run SQL queries directly from VBA. You’ll learn to use ADODB (ActiveX Data Objects) to send and receive data between Excel and databases like SQL Server, Access, or MySQL. The course covers writing and executing SQL statements such as SELECT, INSERT, UPDATE, and DELETE, as well as handling query results inside worksheets. You’ll also explore how to build dynamic queries, use parameters for security, and manage connections efficiently. By the end, you’ll be able to automate data retrieval and reporting tasks, turning Excel into a powerful database management tool through VBA and SQL integration. WiseOwlTutorials

To Register in Course you have to watch at least 30 Second of any lesson

What You'll Learn

Write SQL SELECT, INSERT, UPDATE, DELETE statements within Excel VBA for database management
Establish and manage secure database connections using ADODB in Excel VBA projects
Automate data retrieval, updates, and reporting tasks by integrating SQL queries with Excel VBA
Create dynamic, parameterized SQL queries to enhance security and flexibility in data operations

Course Content

46 Lessons • 20 h 35 m total

Excel VBA Introduction Part 58 1 SQL for Excel Files Basic Select Statements

40:08

Excel VBA Introduction Part 58 2 SQL for Excel Files Sorting Rows in a Query

16:03

Excel VBA Introduction Part 58 3 SQL for Excel Files Selecting the Top N Rows

15:08

Excel VBA Introduction Part 58 4 SQL for Excel Files Selecting All or Distinct Rows

18:24

Excel VBA Introduction Part 58 5 SQL for Excel Files Adding Criteria to a Query

1:21:28

Excel VBA Introduction Part 58 6 SQL for Excel Files Text Criteria and the Like Operator

1:24:13

Excel VBA Introduction Part 58 7 SQL for Excel Files Basic Calculated Columns

46:14

Excel VBA Introduction Part 58 8 SQL for Excel Files Conditional Functions

50:33

Excel VBA Introduction Part 58 9 SQL for Excel Files Nulls in Expressions

30:36

Excel VBA Introduction Part 58 10 SQL for Excel Files Date Expressions

53:13

Excel VBA Introduction Part 58 11 SQL for Excel Files Text Expressions

44:52

Excel VBA Introduction Part 58 12 SQL for Excel Files Aggregation Functions

25:00

Excel VBA Introduction Part 58 13 SQL for Excel Files Grouping Rows

28:22

Excel VBA Introduction Part 58 14 SQL for Excel Files Criteria in the Having Clause

16:09

Excel VBA Introduction Part 58 15 SQL for Excel Files Pivoting Data Crosstab Queries

20:08

Excel VBA Introduction Part 58 16 SQL for Excel Files Basic Union Queries

19:53

Excel VBA Introduction Part 58 17 SQL for Excel Files Union Queries with Total Rows

28:59

Excel VBA Introduction Part 58 18 SQL for Excel Files Union Queries from Multiple Files

12:48

Excel VBA Introduction Part 58 19 SQL for Excel Files Inner Joins

30:24

Excel VBA Introduction Part 58 20 SQL for Excel Files Outer Joins

25:36

Excel VBA Introduction Part 58 21 SQL for Excel Files Constructing Full Outer Joins

19:47

Excel VBA Introduction Part 58 22 SQL for Excel Files Join Worksheets from Multiple Files

12:39

Excel VBA Introduction Part 58 23 SQL for Excel Files Merge Worksheets Side by Side

24:22

Excel VBA Introduction Part 58 24 SQL for Excel Files Consolidate Worksheets with Derived Tables

24:08

Excel VBA Introduction Part 58 25 SQL for Excel Files Basic Subqueries

25:54

Excel VBA Introduction Part 58 26 SQL for Excel Files Nested Subqueries

17:20

Excel VBA Introduction Part 58 27 SQL for Excel Files Correlated Subqueries

26:36

Excel VBA Introduction Part 58 28 SQL for Excel Files Inserting Data into an Existing Sheet

26:17

Excel VBA Introduction Part 58 29 SQL for Excel Files Select Data into a New Sheet or Workbook

18:37

Excel VBA Introduction Part 58 30 SQL for Excel Files Updating Existing Data

26:13

Excel VBA Introduction Part 58 31 SQL for Excel Files Split a Table into Separate Sheets

18:23

Wise Owl Answers How do I select more than 255 columns using ADODB with VBA

28:20

Wise Owl Answers How do I refer to a field name with a dot in ADODB

5:17

Wise Owl Answers How do I find the data type of a column in an ADODB recordset

30:01

Wise Owl Answers How do I count the rows in an ADODB recordset

5:58

Wise Owl Answers How do I populate an array with an ADODB recordset

9:40

Wise Owl Answers How do I add a filename to the results of an ADODB query

12:05

Wise Owl Answers How do I get data from a CSV file using ActiveX Data Objects

23:41

Wise Owl Answers How do I get the column names from an ADO recordset

18:05

Wise Owl Answers How do I populate a listbox using an ADO recordset in VBA

20:41

How to Get The Certificate

You must have an Account on the platform.
Complete all lessons.
Watch at least 50% of Lesson Duration.
Get your Certificate free 🎉 !

5.0 (1 review)

Overall rating

5.0 100%
4.0 0%
3.0 0%
2.0 0%
1.0 0%

Reviews

Mahek Yadav

· 9mos ago

Easy to understand and well explained.

Odinaev

· 1yr ago

oke

Excel VBA writing SQL Course Description

Excel VBA writing SQL, in this course teaches you how to connect Excel to databases and run SQL queries directly from VBA. You’ll learn to use ADODB (ActiveX Data Objects) to send and receive data between Excel and databases like SQL Server, Access, or MySQL. The course covers writing and executing SQL statements such as SELECT, INSERT, UPDATE, and DELETE, as well as handling query results inside worksheets. You’ll also explore how to build dynamic queries, use parameters for security, and manage connections efficiently. By the end, you’ll be able to automate data retrieval and reporting tasks, turning Excel into a powerful database management tool through VBA and SQL integration. WiseOwlTutorials

Focus on Learning, Not Ads

Experience the full power of Mindluster with Premium.
No distractions, just pure education.

Get Mindluster Premium

Cancel your subscription anytime