How to generate SQL commands from excel where the commands are ready to execute

[bgurukishore]

Am looking the formula to generate SQL commands from excel data where the commands are ready to execute in SQL/DB server.

 

[Excel_Kid_663]

As far as I know you cannot use SQL language in excel, maybe you could use a text string though to write SQL syntax? For Example:


=IF(A1 = "Yes", "SELECT * FROM Table_Name WHERE Criteria >= 100", "")


Then the Cell will only display /SELECT * FROM Table_Name WHERE Criteria >= 100/


Not sure if that's any help