Tricks for generating SQL statements in Excel

Tricks for generating SQL Statements ,Mainly Insert ,Update in Excel for various data import scenarios?

This is one of the very powerful feature of the excel ,suppose of you have very large amount of data stored in excel sheet.

Now you want to store that data into DataBase Table,for that you have to use this feature of the Excel .

I am giving you the example of it.

ex.

1.CONCATENATE("insert into table (id, name) values (",C2,",' ",D2," ');")

-->here the c2 and c3 represent the respective column we need in our query.

2.=CONCATENATE("UPDATE ProfileData SET PrependUsername = '",A1, "' WHERE Username = '", B1, "'")

-->this is also work same for update query.

for graphical example see the images.