Excel VBA Introduction Part 58.30 - SQL for Excel Files - Updating Existing Data

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:47 The Basic Setup
01:49 The Update Statement
04:20 Removing Values from a Column
05:50 Empty Columns and Data Types
07:00 Using Cell Formatting
08:42 Tables with No Headers
11:16 Updating Data using Calculations
13:39 Using Criteria to Update Specific Rows
15:16 Updating from a Different Worksheet
16:59 Attempting to Use Data in a Separate Workbook
19:45 Importing Data from a Separate Workbook
23:48 Avoiding Duplicate Names

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