The text file Employees Details by Role.txt is not importing the data properly. As the columns are not in proper order. screen shot attached. Would appreciate some help.
File looks ok to me. Can you please share the screenshot of the error that you are receiving.
I figured it out. I think it may be to do with the version of the txt file. I had to save it as a csv file before I imported. So this may be something that you may want to discuss further. Just finished my exam. Thanks for all your help. Have a lovely evening.