Here’s what I tried:
- I tried to rename the column names in Access database as well as in the Excel file by replacing blanks with underscore. I suspected that might be the cause.
- I had the Continue on Error property to True (in error) and that’s the reason for not displaying the error message and was failing silently.
Now the error message that is displayed is: