Скачать или смотреть Excel VBA Introduction Part 58.1 - SQL for Excel Files - Basic Select Statements

Writing SQL for Excel with ADODB playlist    • Excel VBA Writing SQL for Excel using ADODB  
VBA Working with Databases playlist    • Excel VBA Working with Databases  

Get files here https://www.wiseowl.co.uk/vba-macros/...

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!

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?

Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Power BI, DAX, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access and more