![How to Insert Into a Table Using Excel to Write SQL How to Insert Into a Table Using Excel to Write SQL](https://i0.wp.com/www.mlakartechtalk.com/wp-content/uploads/2018/07/Insert-Table-from-Excel-Write-SQL.jpg?resize=598%2C472&ssl=1)
Today I want to show off a quick trick I learned many years ago that is useful to this day.
The Scenario: you have a spreadsheet, CSV file, or some other delimited flat file and need to load that into a database. There are many options to load data into SQL Server; however, a quick method I am fond of is to use Microsoft Excel and manipulate the data to craft insert statements then paste into SSMS and execute.
Read on to see how to parse and load a CSV flat file, character delimited flat file, and columnar text.