An unexpected error has occurred (-2147467259) when Importing spreadsheet

I trying to Import from Spreadsheet to create a list and the above error occurs - the site is trusted and office activated - I have tried various spreadsheets so its not a number of cells issue. Can anyone assist please.

A month ago, I installed SharePoint Designer 2007 to test something and since then the import stopped working.