|
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...
Exam 77-885: Microsoft Access 2010
2. Building Tables
2.5. Import data from a single data
file: Append Data into an Existing Table
Microsoft
Access->External Data ->Import & Link-> Excel |
|
| |
