Excel VBA Introduction Part 58.28 - SQL for Excel Files - Inserting Data into an Existing Sheet
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 teaches you how to use INSERT INTO statements in SQL to insert data into an existing Excel worksheet. You'll learn how to insert a single row of specific values, how to insert rows selected from a different worksheet and how to insert rows from a different Excel file. You'll also see how to use outer joins to avoid inserting duplicate rows and how to use union select statements to insert rows from multiple worksheets, ranges and workbooks at the same time.
Chapters
00:00 Topic List
00:43 The Basic Setup
02:51 Inserting a Single Row
05:33 Deleting Rows from a Table
08:20 Choosing Which Columns to Populate
09:30 Inserting Data from a Different Worksheet
11:34 Inserting Specific Rows from a Different Sheet
12:43 Inserting Rows from Multiple Ranges or Sheets
16:04 Avoiding Duplicates Using Joins
20:36 Inserting Data from Different Files
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
Watch video Excel VBA Introduction Part 58.28 - SQL for Excel Files - Inserting Data into an Existing Sheet online without registration, duration hours minute second in high quality. This video was added by user WiseOwlTutorials 18 July 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 7,766 once and liked it 101 people.