SQL Insert Statements from Excel

Shows how to use Microsoft EXCEL functions to create SQL INSERT statements from tabular data.
It also shows how to extract date from a picture.
00:00 Introduction
00:58 Pasting data from Picture
02:15 Microsoft Excel TEXTJOIN() function usage to concatenate data with a delimeter.
04:15 building the structure of an insert statement with TEXTJOIN()
06:28 CONCAT() function to join cell text without whitespace
07:05 SUBSTITUTE() function for removing 'NULL' and replacing with NULL
08:50 TEXT() function to get a suitable format for SQL DATE insertion.