|
The Import
Wizard asks questions. The first step in the Wizard asks you to find
the data that you wish to import. The Wizard also asks asks you
where you would like to store the data in your current database.
3.
Try it: Browse for the Data Source The
database is still open. The Import
Wizard is on step 1. Place your
cursor to the right of the File Name. Browse
to your Documents folder. Select:
tblMovies.xlsx
Try
This, Too: Specify How to Store the Data The three
import options include: Import
into a new table Append
(add) records to a table Link
to an external table Select:
Import the source data into a new table. Click OK. Keep
going...
Exam 77-885: Microsoft Access 2010
2. Building Tables
2.5. Import data from a single data
file: Import into a New Table
External Data ->Import & Link->Excel |
|
| |
