importing formatted spreadsheet
I have previously asked for ( and received ) help in my quest to import data from excel into SIMS assessment manager. I have set up the aspects, Templates and empty marksheets in SIMs and exported the formatted markseets to Excel and populated them with the appropriate information.
I now want to import these formatted markseets back into SIMS. SIMS help say i should use Routines-Data in -Assessment Import from spreadsheet. I started to do this but stopped when I noticed that it had included on the head of my columns todays date. I can't see how SIMS will put this data into the appropriate year for the boys concerned. The result sheets are from several years ago. Can anyone tell me how to ensure that the data will be allocated correctly in the SIMS assessment manager database.