SQL UNION Query resultsets copied to a table using VB

[nelson]

anyone here know how to do this? I tried OpenRecordSet("SQL UNION") but I get an error saying OpenRecordset is not for UNION is there a work around for this using VB ? Thanks in advanced.

 

[Pat Hartman]

You can create an append query that is based on the union query and run that.

 

[nelson]

i fixed the issue, I just bloody convert it to Excel and ask the user to open that excel file in the My Documents so they can do their Mail Merge... That way it's convenient...

 

[Pat Hartman]

It's too bad you give up so easily. How is starting a different application easier for the user?

 

[nelson]

i spent 4+ days thinking about it, user dont have to open the file, they simply open the Word/Outlook, and start doing mail merge using the Excel file located in their MyDocuments...which I think way better because their requirements changes all the time. hehehehehe I got plenty of stuff to do...now have to do the data entry !!! *SIGH* ...major headache...