Sure. Just copy it from the SQL view in the query, paste it into code, and then add quotes and line breaks where needed.

Hi, I wanted to know if the quotes and lines breaks could be added by vba.

Thanks
John

No... but I could probably write a little routine that would do it... would make an interesting little video. I'll add it to the TechHelp list. :)

Figured it out in about 30 seconds. I made a neat little tool to do it. TechHelp video coming soon for it...

How does this look for tomorrow's TechHelp video? I'll run down the basics of how to do it in the Free TechHelp video, and then I'll go over the really cool extra stuff I added in the Extended Cut, like splitting up long lines, picking a query from the list of queries in the database, and adding the commands.

Wow! This is the part that concerns me - "Figured it out in about 30 seconds."  John

Richard,
Great idea. This would save a lot of time.

Yeah, I figured out the basics of how to do it in about 30 seconds. It's just simple string manipulation. As long as you understand the vbNewLine character, it's not that hard. Then I ordered a pizza for dinner last night and while I was waiting for the pizza to arrive I decided to flesh it out a bit. Getting ready to record the videos now. :)

Here you go, John. It took me three times as long to record the videos than to build the actual database. But, that's what I do. Hopefully it will help other people as well. Convert SQL to VBA. You've been enshrined in TechHelp glory. You're famous now.