i have four different sql , i saved it as text file and read it as string to query database, is there a way to union these four sql together, cos i want all these return in one place. i know it can be done in excel worksheet, but how to write it in vba code? thanks a lot!