Append Data to a Table:

Review the Data

5. Try it: Review the Table Records

Go to All Access Objects->Tables.
Open a Table: tblMovies.
The Table should open in Datasheet View.
 

Know Your Numbers! This Table began with 401 Records. There are now 411 Records, so all 10 new movies were imported from the Excel spreadsheet.

 

What Do You See? There are two copies of the same movie, The Hunger Games (2012.) 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.

 

Close the Table. Let's create the Find Duplicates Query.

All Access Objects->Tables

Exam 77-885: Microsoft Access 2010

2. Building Tables

2.5. Import data from a single data file: Append Data into an Existing Table