UNION and INTO

L

Lars Brownies

I have a unionquery string of which I want to make a table. How do I code
this tablemakequery?

The code beneath obviously doesn't work.

"SELECT (" & strSQL & ").* INTO TEST "
"FROM " & strSQL & ";"

Can someone point me in the right direction?
Thank you,
Lars
 
A

Arvin Meyer MVP

The easiest method is to create a second query as a Make-Table which uses
the Union query as a source.
 
Top