|
This step
compares the Fields in the External Data to the Fields in the
existing Table. The Field Names AND Data Types need to MATCH. Text
goes with Text. Numbers go with Numbers.
4.
Try it: Confirm the Header Row This
sample spreadsheet has a Header Row. The Header Row contains all of
the Field Names: Movie, Year, Rating, etc. Everything
looks good. Click
Next. Try
This, Too: Import to Table Confirm
the Table: tblMovies. Click
Finish to close the Import Wizard. If the
Save Import Steps window is open you can simply close it So, did
the Wizard append (add) these movies to the right Table?
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 |
|
| |
