Thanks to all who took the trouble to post an answer.
I have now been able to resolve the problem. In the end I have used suggestion that were commonly supplied. I believe this problem was a result of a number of issues.
- Having Office 2013 installed as 32bit (no Access database in my installation) - resolved in part by reloading as 64bit.
- I have v20.0 of SSMS installed that is 64bit but I believe the import wizard may be 32bit?
- I had to load another program before I could load the ACE redistribution
- I loaded ACE OLEDB 16 64bit redistribution software but had to force the loading of the 32bit. note. the x86 32bit version did not work. I can now get past this stage in the import process for excel but I have to select
- Microsoft Excel 2016 - (2013 doesn't work)
- For Destination I have to select 'Microsoft OLE DB Provider for SQL Server
I can see the local Server and database I am working with on my laptop in the Wizard, but it currently wont connect, but that is another question for later if I can't resolve it. Looks like security or a port issue.