Not quite sure how to go about setting up tables for a database which will involve staff and pupil timetables.
I have an excel file with teachers names in column A. With their lessons from monday1 through to friday5 as the headings of columns B to X
The cells contain teachers classes. This file has been exported from a database which the school uses called Sims.
Can I import that worksheet into one table in access or should I try and extract info into more than one table.
Can anyone advise?