Follow along with the video using the provided files and tutorial.
The steps in the video can be found in the tutorial and files below:
Files
https://drive.google.com/drive/folders/1gs2GYfnGU7IaexgjjcMEccklvb_KG6iQ?usp=sharing
Tutorial
In this tutorial , we wish to import the following data from RegionData.xlsx:
| Region | Population Size |
| Couva–Tabaquite–Talparo | 178,410 |
| Diego Martin | 102,957 |
| Mayaro–Rio Claro | 35,650 |
| Penal–Debe | 89,392 |
| Princes Town | 102,375 |
| San Juan–Laventille | 157,258 |
| Sangre Grande | 75,766 |
| Siparia | 86,949 |
| Tunapuna–Piarco | 215,119 |
NOTE: If you don’t have the provided excel file, you can always copy and paste the table above into a new excel document, save it, and use it for this tutorial.
- Add a new table named Region. The design View Is shown Below:
Close the table after creation.
2. “RegionData.xlsx” contains data formatted to match the region and population size of our Region table. The column names are the same in both tables. Start the process to Import the data from “RegionData.xlsx”:
a) Select the “External Data” tab
b) Choose “New Data Source”
c) Hover over “From File”
d) Choose Excel
3. Use the wizard:
a) Browse to and select “RegionData.xlsx”
b) Choose “Append a copy…”
c) Select the region table from the dropdown
4. Choose Next:
5. Choose Finish
6. Choose Close:
7. Done! Open your table to verify that the data was imported:
© 2021 Vedesh Kungebeharry. All rights reserved.
Island Class 