I would break that into 2 arrays. The first would be line one and use the comma delimiter. Break that first line of SQL into several small parts for each element where the comma is left off to be readded by a Join().

The second would poke the first Join() string from array one into the first element of array two. Add the other lines of SQL. Use the vbCRLF delimiter for the Join() of array 2.