Combine two tables in Access

[Guest]

Is it possible using SQL in Access to copy all the data in TableB into TableA?

If so, could someone please post the SQL to do so?

Thanks in advance.

 

[Guest]

Sorry, I forgot to add that the two tables, both in the same Access DB have
identical data types and columns in the same order...

 

[Guest]

Try...

INSERT INTO tblCompany SELECT tblCompany1.* FROM tblCompany1;