Exam 77-424: Microsoft Access 2013 2.0 Build Tables 2.3 Manage Records: Append Records from External Data (Excel)

Append Data to a Table: Select a Worksheet 3. Try it: Select a Worksheet or Range An Excel workbook can have more than one spreadsheet or Named Range.   The Import Spreadsheet Wizard will ask you to confirm which Worksheet has the data. You can select a Worksheet or a Named Range.   Select a worksheet: New Movies.   What Do You See? The sample data for tblMovieTitles looks like the spreadsheet we just reviewed. So, we are good to go.   Click Next. Keep going... Microsoft Access->External Data ->Import & Link-> Excel