Using UNIONs in a INSERT INTO statement

[rmuller]

Hi,

The following code does not work in Access (up to 2002):

INSERT INTO <table> (<columnlist>)
SELECT <columnlist> FROM <table>
UNION
SELECT <columnlist> FROM <table>
UNION
....

Who knows a alternative solotion (w/h temp. tables)

Ronald

 

[MichaelRed]

One Select into (Make Table)
N Append tos (Append) MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over

 

[tlbroadbent]

Save the Union query. Then use the saved Union query as the source in the append query. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.