APPEND Query - can't get it

  • Thread starter Thread starter PBS
  • Start date Start date
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
 
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????
 
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
 
Back
Top