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