The string is fine as far as strings go. You might want to add some vbCRLF to make it more readable like a standard SQL string.

Whether it meets SQL syntax standards is where you have problems I suspect. I don't know what database you are trying to connect to. If you can make the SQL string there, and it runs ok, post that string here and I will show you how to build it.