Error when importing excel (1 Viewer)

ridders said:

I couldn't see any difference to the original Excel file ....

I've spent about 30 minutes trying different ways of fixing your dates:
See below & attached file

Nothing I tried worked.
I'm not saying its impossible to fix but I've spent too long on it already

My suggestion is to abandon trying to fix it & re-enter the dates
Insert an extra column in Excel, format it as UK date e.g. dd/mm/yyyy then re-enter the data correctly
Once that is done, delete the original data in column B

Click to expand...

JHB said:

The only solution I can come up with just now is Copy and Paste method.
All other solutions I've look at could save one problem but then another problem occurs.
Click the "Copy from Excel" button, the result is saved in Book2 table.

Click to expand...