By Andrew Gould

Writing SQL for Excel with ADODB playlist https://youtube.com/playlist?list=PLNIs-AWhQzckUd5i0E1xeSFeBAonYIurK
VBA Working with Databases playlist https://youtube.com/playlist?list=PLNIs-AWhQzclbRVLCZlsFvpz6fz2nPGbt

Get files here https://www.wiseowl.co.uk/vba-macros/videos/vba-ado-net-recordsets/sql-excel-select-new

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:
https://www.youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw/join
Or you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!

This video teaches you how to use SELECT INTO statements in SQL to insert data into a new Excel worksheet. You'll learn how to insert a data into a new worksheet in the same workbook as the selected data, how to insert into a new worksheet in a different existing workbook and how to insert data into a new worksheet in a new workbook.

Chapters
00:00 Topic List
00:33 The Basic Setup
02:41 Selecting Data into a New Worksheet
04:05 Range Names and Sheet Names
06:31 Deleting the Output Worksheet
07:32 Deleting Worksheets and Range Names
11:13 Making Range Names Unique
13:19 Selecting into a Different Existing Workbook
16:25 Selecting into a New Workbook

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