Excel VBA Introduction Part 58.31 - SQL for Excel Files - Split a Table into Separate Sheets

By Andrew Gould

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 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 explains how to update existing data in an Excel workbook using SQL UPDATE statements. You'll learn how to assign a simple value to a column, how to calculate a new value to produce a different result for each row, and how to update information in one worksheet using information stored in a different worksheet. The final part of the video discusses how to import data from a separate workbook using a SELECT INTO statement and then use the imported data to update existing data.


Chapters
00:00 Topic List
00:40 The Basic Setup
02:18 Selecting Unique Values into a Recordset
03:45 Looping Through a Recordset
04:53 Creating a Command Object
06:19 Building a Dynamic SELECT INTO Statement
09:37 Creating New Sheets in the Same Workbook
10:26 Worksheets and Range Names
12:43 Creating a Single Output Workbook
15:49 Deleting Output Files
16:56 Creating a Separate Workbook for Each Output

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