CSV is often used for storing and exchanging data. Sometimes you will want to load that data into a relational database using SQL. You can easily create the SQL commands using Easy Data Transform:
In the right pane add the SQL command in Substitution script, leaving gaps where the values from the columns in the CSV files will go. Then insert the column values into the text using the Insert variable drop-down list. Set New column name to ‘SQL’.
Click Evaluate when you are done. A new ‘SQL’ column is added at the end of the table.
Set the table to Show all rows, click on the ‘SQL’ column to select it and copy it to the clipboard using Ctrl+C (Windows)/Cmd+C (Mac).
You can now paste the SQL into wherever you need it.
If you have large number of files to convert you can do it using the batch processing feature.
Substitute is just one of the 50 transforms in Easy Data Transform you can use to quickly and easily create a wide range of data transformations. See our quick start guide for more details.
v1.15.1 for Windows 10 / 8 / 7 (31 MB)
v1.15.1 for Mac 11.x to 10.13 (32 MB)
Questions or problems?