I resolved the above error by running the Office Setup routine from the installation disk. Incidentally, you’ll need to use 32 bit Internet Explorer when importing your spreadsheet as a list.
However, I still had an issue, where once i’d clicked ‘Import’, the following error occurred:“An unexpected error has occurred.” Handy. Not.
However, the following Microsoft Support Article helped resolved the issue:
It would appear that you have to append ‘&ListBaseType=0&DisplayName=Spreadsheet+Import‘ to the URL of the import page.
Thanks to the following websites for help with this: