I am importing files originally created with Excel 2000 and saved as CSV. Most of my imports are fine, but one file is always fails with the error "column no. 4 should have a name". There are only 3 columns in the CSV file. If I add a 4th and give it a name, the error simply increments the column number and repeats ("column no. 5 should have a name"). Nothing I do seems to change this. I am new to SQlite Manager. Any help would be appreciated.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I am importing files originally created with Excel 2000 and saved as CSV. Most of my imports are fine, but one file is always fails with the error "column no. 4 should have a name". There are only 3 columns in the CSV file. If I add a 4th and give it a name, the error simply increments the column number and repeats ("column no. 5 should have a name"). Nothing I do seems to change this. I am new to SQlite Manager. Any help would be appreciated.
Problem solved: There was a hidden column between two of the other columns.