I need to find a way to upload the previous enrolments for the Global Enterprise Experience ([[login to view URL]][1]) that I have been manually piecing together into an excel spreadsheet and convert it back to an mdb file and then upload it to the site. We had a go at it but the system wanted us to clean the data first - eg the phone numbers needed to look like text or numbers (I forget which) and a couple of other easy things. So we sorted this out.
But then there were two bigger problems that we could not work out how to fix. In the autonumber column where each record gets a separate number, it would not allow us to convert the excel to an mdb file with numbers in this column and still keep it as an autonumber system.
And then the next problem was that it would not let us upload a new mdb file to replace the existing one (which was probably just as well as it would not have worked without the autonumbering.)
## Deliverables
I am not sure if I have correctly specified what needs to be done as I do not have any IT skills. If I have incorrectly specified it could you please let me know so I can make the changes.
The excel file currently has about 250 records and will grow quickly over the next week or so as enrolments flood in before the deadline. I could manually re-enter the data but I suspect I could strike this problem of the on-line database not exactly matching the enrolments again in the future. I am sure you will be much clearer about what needs to be done to fix the problem than the way I have specified it - if so I will make the requisite changes.