Convert access query to sql and export statement to text (1 Viewer)

[zentel]

My appologies,
You are a genius. sorry, for some reason I overlooked your last post.
It actually works for what I need.
Now I need to figure out way to but this inn vba and export as a text file or possibly a *.sql file.

Again thank you so much and very much appreciated.

Ok, then how about try my SQL solution?

 

[plog]

Ugh, you get an idea in your head and just can't let it go. There is no need for VBA.

Create the query I suggested, once done and it works you right click on it select Export->Text File and then walk through the wizard. That will generate your file. Change the extension of that file to .sql if you like.