|
There is an
Import
Spreadsheet Wizard
that
walks you through the process
of importing data into Access. The steps ask to find the data and
identify the Header Row
2. Try it: Get External
Data
The Front Row Video
database is open.
Try This, Too: Browse for
the Data Source
Select:
tblMoviesNEW.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: Append and
choose a Table: tblMovies.
Click OK. Keep
going...
Microsoft
Access->External Data ->Import & Link-> Excel
Exam 77-885: Microsoft Access 2010
2. Building Tables
2.5. Import data from a single data
file: Append Data into an Existing Table |
|
| |
