Generate insert SQL statements from a CSV file
It’s a bit crude – but for one off jobs, I sometimes use Excel. If you import the CSV file into Excel, you can create a formula which creates an INSERT statement by using string concatenation in the formula. So – if your CSV file has 3 columns that appear in columns A, B, and … Read more