Append Data to a Table:
Review the Data
5. Try it: Review the Table Records
Go to All
Open a Table: tblMovies.
The Table should open in Datasheet View.
Your Numbers! This Table began with 401 Records. There are now
411 Records, so all 10 new movies were imported from the Excel
You See? There are two copies of the same movie, The Hunger
Apparently, there are duplicates in this Table.
Yeah, there's always more
work to do, isn't there? Luckily, there is a
Query Wizard that will help you find the repeats.
Table. Let's create the Find Duplicates Query.