Excel VBA Introduction Part 58.1 - SQL for Excel Files - Basic Select Statements

The first video in our tutorial on writing SQL for Excel files with ADODB shows you how to write basic Select statements to retrieve data from a separate Excel file. You'll learn how to refer to worksheets, cell references and range names and how to deal with worksheets with no column headers. You'll also see how to write a Select list to pick a specific set of columns from the Excel source and how to rename source columns by using aliases in your query. The final part of the video discusses different ways to lay out a longer SQL query, including the controversial topic of where to put your commas!

Chapters
00:00 Topic List
01:19 The Basic Setup
03:43 Referring to a Worksheet by Name
04:45 Getting Data from a Closed Workbook
05:30 Selecting a Specific Range of Cells
07:10 Using Named Ranges
08:28 Creating Range Names
10:04 Using Square Brackets Around Identifiers
11:20 Using Worksheet Scoped Range Names
13:13 Tables Without a Header Row
15:27 Writing a Basic SQL Select Statement
17:34 Referencing Cells and Ranges in the From Clause
19:03 Selecting Specific Columns by Name
21:34 Selecting Columns Without Names
23:33 Assigning an Alias to a Column
25:03 Replacing Existing Column Names
26:14 Using Table Aliases
29:17 Changing the Query Layout
31:27 Separating Keywords onto Different Lines
32:45 Placing Column Names on Separate Lines
34:18 The Controversy of Comma Position
37:49 Formatting SQL Code Quickly
39:42 What's Next?

[youssefsedkey]

The most beautiful thing is that you walk step by step with the learner and I couldn't find anyone explaining a lesson in all these details ... Andy, please keep going in this way.

[nordicdust]

There is no one like you Andrew, you were put on this earth to teach, and you do so. So many thanks for your help.

[peterM]

Andrew, you are a gift that we don't deserve. I know I have told you this countless times but no matter what we say to express our appreciation of your work, it will never be enough. thank you for all that you do. your delivery is unmatched in all of YouTube.

[jmathew]

I wanted to write a comment as a thank you for this tutorial. I also happened to read through some of latest nice comments left by previous viewers and discovered that those are exactly the impressions which I echo. 🙂

Sir, you truly are a blessing to students. I just cannot thank you enough for the immense help that WiseOwl VBA tutorials have been for me.

[busybillyb]

5:30 This is exactly what I needed! I was referred to this video by you from a question I had asked in another tutorial. You have an extensive collection of topics that sometimes it is not so much as me not being able to look for what I needed but it is that I don't know what I should be looking for. Thanks for making enough sense of what I was asking to point me to the right place!

[thwbn]

I wished teachers in my son's school would teach only half the quality level you do! Thanks a ton! Done again!!

[cpro]

Great setup and intro to the new series; looking forward to the next episodes...

[alexsandoval]

24 / 5000

beautiful way of teaching ...

[efernandes]

Great as always! Awesome presentations and explanations. Keep the good work. "See You" on the next one.

[juanpablohorn]

Such a great video! I'm eager to see how this series unfolds! I find it really useful!

[imranbhatti]

Thanks, Andrew! This video answered a lot of my questions before asking.

[krn]

Thanks Andrew, was looking forward to this series. :)

[RohithKK-uhpp]

Excellent. I have learnt many things. Much more thanks.

[jorgeluisrodriguezescudero]

I have only one thing to say: thank you Andrew. After i saw your videos, i only know that i know nothing .

[frikduplessis]

Thank you Andrew, this is what I was waiting for I really appreciate the detail and effort you have put in with this wonderful article, I surely hope you are just building up to something special, 👏👏👏👏👏👏 thank you again👏👏👏👏👏

[piotrkuc]

Thank you!
Looking forward to learn more!

[teodorohturnos]

Thanks Andrew. Another great video start of a super interesting series. I never used SQL until today and I most probably would not have started using it, if you would not do this superb VBA "Introduction"!!! videos.

[KhalilYasser]

Awesome. Thank you very much for these amazing tutorials.

[ozofriendly]

Excellent & meticulous introduction, Andrew. PoorSQL bookmarked! :)

[naiduvikas]

7:00
In this place I want to use a range like the last used row in that specific table like Range("A2:D" & Last-row). Could you please suggest how we can achieve this criteria by using record set