Excel VBA Introduction Part 58.4 - SQL for Excel Files - Selecting All or Distinct Rows
Автор: WiseOwlTutorials
Загружено: 2021-05-23
Просмотров: 6672
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!
In this video you'll learn how to use the All and Distinct keywords in your SQL query to return either every row from a data source or just the rows with unique values. You'll see how to affect the sorting of the query results using the Order By clause and how to use unique row values to provide users with a choice using drop down lists on a user form.
Chapters
00:00 Topic List
00:39 The Basic Setup
03:06 Using Select All
04:35 Using Select Distinct
05:40 Referring to Different Columns
06:27 Changing the Sort Order
07:22 Including Multiple Columns
08:46 Sorting by Different Columns
10:09 Using Distinct Rows for Drop Down Lists
12:18 How the User Form Works
15:43 Beware of SQL Injection!
17:54 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
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
