Combine two tables

[krets]

Something happened to one of the tables in a database I designed. I have no idea what happened as the guy who maintains it will either not tell me or really has no clue.

Basically what I have is a database with a table called tblAITInfo that is missing all entries from 5/22 to 6/12. I have another copy of the table that was retrieved from our nightly tape backup and it has the missing entries except those on 6/12. So it has 5/22 to 6/11.

What would be the best way to grab those entries from the backup table and add them to the other one?

 

[genomon]

Link and rename the table that has the missing data tblAITInfoA.
Use SQL in a query, something like:
INSERT INTO tblAITInfo SELECT * FROM tblAITInfoA
WHERE Datefieldname BETWEEN #5/22/2007# AND #6/12/2007#.

10 is company, 11 is a crowd

 

[ajetrumpet]

Just use an append query to add those records to the biggest table. Then make a new table query from that combined record set.