Excel - Concatenate function to create SQL

About

How to create a function in order to create a SQL statement in Excel with the CONCATENATE function.

Articles Related

Steps

• Add a simple quote before all single quote in the data columns

• Then write a formula column as below

In English

=CONCATENATE("INSERT INTO TABLE (COLUMN1, COLUMN2) VALUES ('"; $A2; "', '";$B2; "');" )

In Dutch

=TEKST.SAMENVOEGEN(("INSERT INTO TABLE (COLUMN1, COLUMN2) VALUES ('"; $A2; "', '";$B2; "');" )

• Copy/paste in an SQL Ide as Oracle Sql Developer
• And execute the script