In the Data Import wizard I can select a range in a xlsx format excel file but when I highlight and accept the input range, I get, "error reading from data file, check the file format and file encoding" "Unable to Loadfile".Grateful if someone would help me on working through this.I am a total newbie and have so far just created a new database with the above as first step undertaken.
I also faced the same issue, and below is how I was able to resolve.
The workbook I was importing data from had 2 tabs (Tab1, Tab2).
First I selected the range from Tab1 and got the error message "Unable to load file".
I simply switched to the Tab2 and then back to Tab1.
Now the Import Wizard automatically read the range that I have provided earlier and I was able to import the data in the table.
Hope this helps you.