UNION and INTO

  • Thread starter Thread starter Lars Brownies
  • Start date Start date
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
 
The easiest method is to create a second query as a Make-Table which uses
the Union query as a source.
 
Back
Top