When trying to do data import of csv file, I was getting error message "The column heading cannot be empty", when opening the file in ms-excel sheet data looks fine, with valid column names.
Reason: open the file in notepad and then will see extra coma at the end of each record including the heading this is some one tried to enter some data in excel file and then later on decided to delete the data, however ms-excel record that as a valid data column and hence the error was occurring,
Resolution: open file in ms-excel and select empty cells and rows and press delete button visually there might not be any effect but it deletes any selected empty column/rows, other wise open file in csv format and then delete unnecessary data.
Reason: open the file in notepad and then will see extra coma at the end of each record including the heading this is some one tried to enter some data in excel file and then later on decided to delete the data, however ms-excel record that as a valid data column and hence the error was occurring,
Resolution: open file in ms-excel and select empty cells and rows and press delete button visually there might not be any effect but it deletes any selected empty column/rows, other wise open file in csv format and then delete unnecessary data.
No comments:
Post a Comment