Excel VBA Introduction Part 58.1 - SQL for Excel Files - Basic Select Statements скачать в хорошем качестве

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