Import Attendance Dates for Courses

Kirsha will send a spreadsheet of class id’s and course dates.  It will look something like this.

ClassID    CourseDate
7943    13-Jan
7943    20-Jan
7943    27-Jan
7949    11-Jan
7949    18-Jan
7949    25-Jan

It will contain a list dates for each class throughout the semester.  Our job is to import this data into the tblClassDates table in William.

How-To

1. Open William in design mode.
2. Click ‘External Data‘.  On the Import tab click ‘Excel‘.
3. Work through the wizard, choosing the spreadsheet and Append a copy of the records to the table.
4. The table that we need to import into is called tblClassDates.

To verify the result open the Attendence tracking form (frmAttendenceTracking – also there a button called Attendence on the Registrar start form).  Click the ‘Classes and Dates‘ button and choose one of the class that you know should have dates associated with it.  The new semester’s date will appear in the Dates field below.