Excel VBA Introduction Part 58.23 - SQL for Excel Files - Merge Worksheets Side by Side
By Andrew Gould
Writing SQL for Excel with ADODB playlist • Excel VBA Writing SQL for Excel using...
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 join this channel to get access to perks:
/ @wiseowltutorials
Or you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
This video shows you how to merge multiple worksheets using a combination of union queries and outer joins. You'll use a union query to create a master list of values to join on and use this query to populate a derived table subquery. You'll join other worksheets to the results of the subquery to produce a side-by-side merged set of results.
Chapters
00:00 Topic List
00:42 The Basic Setup
02:36 Joining Two Worksheets
04:42 Outer Joins
08:41 Creating a List of Genres with Union
10:13 Joining to a Derived Table Subquery
13:18 Replacing Nulls with Zero
14:56 Joining More Worksheets
16:47 Joining the Remaining Worksheets
21:30 Adding a Where Clause
22:47 Adding More Conditions
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
Смотрите видео Excel VBA Introduction Part 58.23 - SQL for Excel Files - Merge Worksheets Side by Side онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь WiseOwlTutorials 06 Июль 2021, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 2,793 раз и оно понравилось 61 людям.