Excel - my favorite code generator

· November 1, 2006

I have spent the main part of the last two days compiling SQL-statements with Excel, and it’s actually quite good at it.

With the string functions (concatenate, substring, find and the usual suspects) you can create SQL-statements for a large number of rows quite simply.

I have a large number of strings that need to be manipulated (done with replace) and then all these string needs to be sent to a stored procedure. This stored procedure call is created by concatenating the string from the manipulated column with the SQL-statement to make the call.

When all of this is done it’s just a matter of filling the columns. Works like charm.

Then i needed about 2 hours to muster the strength to run the script, but that’s another story

Twitter, Facebook