Interoperability is one of the advantages of using a suite of applications such as Microsoft Office!
One of the joys of Microsoft is interoperability between applications such as Access and Excel. A stunning example of this is the Import Excel spreadsheet function for importing Excel data from a worksheet which offers an easy-to-follow wizard-style feature on the External Data menu tab.
In this post:
- No unique value
- With unique value
Required knowledge:
1. No unique value
Data sample:
| FirstName | Surname | Age | Gender | Grade | House |
|---|---|---|---|---|---|
| Charlie | White | 12 | M | 8 | Alpha |
| Belinda | Carlisle | 11 | F | 8 | Beta |
| Johnny | Clegg | 12 | M | 8 | Chalie |
2. With unique value
In the data below is a copy of the above data to which a field that contains unique values has been added. It would be tempting to use this column as the Primary Key for the Access table; however, it is too long and contains characters as well as numbers.
| FirstName | Surname | StudentAccount | Age | Gender | Grade | House |
|---|---|---|---|---|---|---|
| Charlie | White | SNBWH825@school.com | 12 | M | 8 | Alpha |
| Belinda | Carlisle | SNBCA551@school.com | 11 | F | 8 | Beta |
| Johnny | Clegg | SNBCO614@school.com | 12 | M | 8 | Charlie |