×
Create CV Books Summaries Online Courses Blog Communities

Login

Sign up
MindLuster Logo
Categories
Recent

Join Our Telegram Channel Now to Get Any New Free Courses : Click Here

Excel VBA writing SQL

Track :

Computer Science
Course Presenter :

WiseOwlTutorials

Lessons no : 46

For Free Certificate After Complete The Course

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

Join The Course Go To Community Download Course Content

What will you learn in this course?
  • 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

How to Get The Certificate

  • You must have an account Register
  • Watch All Lessons
  • Watch at least 50% of Lesson Duration
  • you can follow your course progress From Your Profile
  • You can Register With Any Course For Free
  • The Certificate is free !
Lessons | 46
Excel VBA Introduction Part 58 1 SQL for Excel Files Basic Select Statements
00:40:08

Excel VBA Introduction Part 58 1 SQL for Excel Files Basic Select Statements
Excel VBA Introduction Part 58 2 SQL for Excel Files Sorting Rows in a Query
00:16:03

Excel VBA Introduction Part 58 2 SQL for Excel Files Sorting Rows in a Query
Excel VBA Introduction Part 58 3 SQL for Excel Files Selecting the Top N Rows
00:15:08

Excel VBA Introduction Part 58 3 SQL for Excel Files Selecting the Top N Rows
Excel VBA Introduction Part 58 4 SQL for Excel Files Selecting All or Distinct Rows
00:18:24

Excel VBA Introduction Part 58 4 SQL for Excel Files Selecting All or Distinct Rows
Excel VBA Introduction Part 58 5 SQL for Excel Files Adding Criteria to a Query
01:21:28

Excel VBA Introduction Part 58 5 SQL for Excel Files Adding Criteria to a Query
Excel VBA Introduction Part 58 6 SQL for Excel Files Text Criteria and the Like Operator
01:24:13

Excel VBA Introduction Part 58 6 SQL for Excel Files Text Criteria and the Like Operator
Excel VBA Introduction Part 58 7 SQL for Excel Files Basic Calculated Columns
00:46:14

Excel VBA Introduction Part 58 7 SQL for Excel Files Basic Calculated Columns
Excel VBA Introduction Part 58 8 SQL for Excel Files Conditional Functions
00:50:33

Excel VBA Introduction Part 58 8 SQL for Excel Files Conditional Functions
Excel VBA Introduction Part 58 9 SQL for Excel Files Nulls in Expressions
00:30:36

Excel VBA Introduction Part 58 9 SQL for Excel Files Nulls in Expressions
Excel VBA Introduction Part 58 10 SQL for Excel Files Date Expressions
00:53:13

Excel VBA Introduction Part 58 10 SQL for Excel Files Date Expressions
Excel VBA Introduction Part 58 11 SQL for Excel Files Text Expressions
00:44:52

Excel VBA Introduction Part 58 11 SQL for Excel Files Text Expressions
Excel VBA Introduction Part 58 12 SQL for Excel Files Aggregation Functions
00:25:00

Excel VBA Introduction Part 58 12 SQL for Excel Files Aggregation Functions
Excel VBA Introduction Part 58 13 SQL for Excel Files Grouping Rows
00:28:22

Excel VBA Introduction Part 58 13 SQL for Excel Files Grouping Rows
Excel VBA Introduction Part 58 14 SQL for Excel Files Criteria in the Having Clause
00:16:09

Excel VBA Introduction Part 58 14 SQL for Excel Files Criteria in the Having Clause
Excel VBA Introduction Part 58 15 SQL for Excel Files Pivoting Data Crosstab Queries
00:20:08

Excel VBA Introduction Part 58 15 SQL for Excel Files Pivoting Data Crosstab Queries
Excel VBA Introduction Part 58 16 SQL for Excel Files Basic Union Queries
00:19:53

Excel VBA Introduction Part 58 16 SQL for Excel Files Basic Union Queries
Excel VBA Introduction Part 58 17 SQL for Excel Files Union Queries with Total Rows
00:28:59

Excel VBA Introduction Part 58 17 SQL for Excel Files Union Queries with Total Rows
Excel VBA Introduction Part 58 18 SQL for Excel Files Union Queries from Multiple Files
00:12:48

Excel VBA Introduction Part 58 18 SQL for Excel Files Union Queries from Multiple Files
Excel VBA Introduction Part 58 19 SQL for Excel Files Inner Joins
00:30:24

Excel VBA Introduction Part 58 19 SQL for Excel Files Inner Joins
Excel VBA Introduction Part 58 20 SQL for Excel Files Outer Joins
00:25:36

Excel VBA Introduction Part 58 20 SQL for Excel Files Outer Joins
Excel VBA Introduction Part 58 21 SQL for Excel Files Constructing Full Outer Joins
00:19:47

Excel VBA Introduction Part 58 21 SQL for Excel Files Constructing Full Outer Joins
Excel VBA Introduction Part 58 22 SQL for Excel Files Join Worksheets from Multiple Files
00:12:39

Excel VBA Introduction Part 58 22 SQL for Excel Files Join Worksheets from Multiple Files
Excel VBA Introduction Part 58 23 SQL for Excel Files Merge Worksheets Side by Side
00:24:22

Excel VBA Introduction Part 58 23 SQL for Excel Files Merge Worksheets Side by Side
Excel VBA Introduction Part 58 24 SQL for Excel Files Consolidate Worksheets with Derived Tables
00:24:08

Excel VBA Introduction Part 58 24 SQL for Excel Files Consolidate Worksheets with Derived Tables
Excel VBA Introduction Part 58 25 SQL for Excel Files Basic Subqueries
00:25:54

Excel VBA Introduction Part 58 25 SQL for Excel Files Basic Subqueries
Excel VBA Introduction Part 58 26 SQL for Excel Files Nested Subqueries
00:17:20

Excel VBA Introduction Part 58 26 SQL for Excel Files Nested Subqueries
Excel VBA Introduction Part 58 27 SQL for Excel Files Correlated Subqueries
00:26:36

Excel VBA Introduction Part 58 27 SQL for Excel Files Correlated Subqueries
Excel VBA Introduction Part 58 28 SQL for Excel Files Inserting Data into an Existing Sheet
00:26:17

Excel VBA Introduction Part 58 28 SQL for Excel Files Inserting Data into an Existing Sheet
Excel VBA Introduction Part 58 29 SQL for Excel Files Select Data into a New Sheet or Workbook
00:18:37

Excel VBA Introduction Part 58 29 SQL for Excel Files Select Data into a New Sheet or Workbook
Excel VBA Introduction Part 58 30 SQL for Excel Files Updating Existing Data
00:26:13

Excel VBA Introduction Part 58 30 SQL for Excel Files Updating Existing Data
Excel VBA Introduction Part 58 31 SQL for Excel Files Split a Table into Separate Sheets
00:18:23

Excel VBA Introduction Part 58 31 SQL for Excel Files Split a Table into Separate Sheets
Wise Owl Answers How do I select more than 255 columns using ADODB with VBA
00:28:20

Wise Owl Answers How do I select more than 255 columns using ADODB with VBA
Wise Owl Answers How do I refer to a field name with a dot in ADODB
00:05:17

Wise Owl Answers How do I refer to a field name with a dot in ADODB
Wise Owl Answers How do I find the data type of a column in an ADODB recordset
00:30:01

Wise Owl Answers How do I find the data type of a column in an ADODB recordset
Wise Owl Answers How do I count the rows in an ADODB recordset
00:05:58

Wise Owl Answers How do I count the rows in an ADODB recordset
Wise Owl Answers How do I populate an array with an ADODB recordset
00:09:40

Wise Owl Answers How do I populate an array with an ADODB recordset
Wise Owl Answers How do I add a filename to the results of an ADODB query
00:12:05

Wise Owl Answers How do I add a filename to the results of an ADODB query
Wise Owl Answers How do I get data from a CSV file using ActiveX Data Objects
00:23:41

Wise Owl Answers How do I get data from a CSV file using ActiveX Data Objects
Wise Owl Answers How do I get the column names from an ADO recordset
00:18:05

Wise Owl Answers How do I get the column names from an ADO recordset
Wise Owl Answers How do I populate a listbox using an ADO recordset in VBA
00:20:41

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


We Appreciate Your Feedback

Be the First One Review This Course

Excellent
0 Reviews
Good
0 Reviews
medium
0 Reviews
Acceptable
0 Reviews
Not Good
0 Reviews
0
0 Reviews

Our New Certified Courses Will Reach You in Our Telegram Channel
Join Our Telegram Channels to Get Best Free Courses

Join Now

Related Courses

Linear Algebra for Computer Scientists
7 Lessons

Linear Algebra for Computer Scientists

Insertion Sort
3 Lessons

Insertion Sort

Bubble Sort
4 Lessons

Bubble Sort

GCSE Computer Science
18 Lessons

GCSE Computer Science

Random Access Memory
7 Lessons

Random Access Memory

Binary Trees
4 Lessons

Binary Trees

Bitwise Operators
4 Lessons

Bitwise Operators

Introduction to Stacks Data Structures
17 Lessons

Introduction to Stacks Data Structures

Organization Theory Structure and Design
41 Lessons

Organization Theory Structure and Design

Handling Large Scale Unit Level Data
41 Lessons

Handling Large Scale Unit Level Data

Introduction to Machine Learning
19 Lessons

Introduction to Machine Learning

Applied Linear Algebra Vectors Matrices
54 Lessons

Applied Linear Algebra Vectors Matrices

Artificial Intelligence beginners
1 Lessons

Artificial Intelligence beginners

Machine Learning Autumn 2018
1 Lessons

Machine Learning Autumn 2018

Robotics and Autonomous Systems
15 Lessons

Robotics and Autonomous Systems

Natural Language Understanding
15 Lessons

Natural Language Understanding

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