INSERT entire table

[timothyl]

After working dozens of hours building a from that builds sql statement to make union quires, I discover that

DoCmd****nSQL (SQL_Text),

Dose not support SELECT statements (sigh).
Can some one tell me if it is possible to use a insert query to insert a table into another table if the fields all have the same names

INSERT INTO mytable(field1, field2, field3, fiel4) myOthertable (field1, field2, field3, fiel4)

Thanks

 

[Banana]

You are actually close.

INSERT INTO mytable(field1, field2, field3) SELECT field1, field2, field3 FROM othertable

 

[timothyl]

OH man, you saved my day with that bit of help, Thanks. Tim

 

[Banana]

Happy to olige.