Excel data to SQL


by Zachary Wenta


This is a paid playlist. Do you want access to it? It is available for sale for $3.00. Click here to purchase
access to the playlist

Often, you'll have data in spreadsheets that need to be inserted into SQL tables. In a professional setting, you'll likely be using SSIS (SQL Server Integration Services) to do this for you, but if you have limited experience, are in a junior role, or simply want to do it quickly - there is an option to do this with regex. In this story, we'll be walking through a hypothetical example on how to take data from a spreadsheet and convert that into SQL you can use to insert the data into a SQL table.
1. Walkthrough