• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

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

B

bgurukishore

New Member
Am looking the formula to generate SQL commands from excel data where the commands are ready to execute in SQL/DB server.
 
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
 
You must log in or register to reply here.
Back
Top