APPEND Query - can't get it

P

PBS

I'm sure this is so simple that it's laughable, but I'm not making any
progress.

Two Tables, identical structures, different data.

Want to append all records from Table2 into Table1. (no concern about
duplicate records or the like)

Can't come up with an APPEND query that does this.

Any help is appreciated.

Thanks,
Paul
 
J

John Vinson

I'm sure this is so simple that it's laughable, but I'm not making any
progress.

Two Tables, identical structures, different data.

Want to append all records from Table2 into Table1. (no concern about
duplicate records or the like)

Can't come up with an APPEND query that does this.

Any help is appreciated.

Thanks,
Paul
Click to expand...

INSERT INTO Table1
SELECT * FROM Table2;

should do it - what problem were you having????
 
P

PBS

John:
Thanks, that did it. My problem was in trying to get the query wizard to
help, as I wasn't sure of the SQL to accomplish it.
Thanks
Paul
 
Top