Does anyone know how to create a relationship between Access and Excel? In Excel I have a column of numbers (PupilID), and next to each number is another number, under the heading DetentionCount. I want the DetentionCount number in the spreadsheet to appear in the DetentionCount field in my access database that corresponds with the PupilID (used as the primary key for each record).
Thanks in advance for your help.
Jamie Caple.
Thanks in advance for your help.
Jamie Caple.