Menu

import fails: "column 4 should have a name"

Help
2017-01-14
2017-01-15
  • John Hoover

    John Hoover - 2017-01-14

    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.

     
  • John Hoover

    John Hoover - 2017-01-15

    Problem solved: There was a hidden column between two of the other columns.

     

Log in to post a comment.

MongoDB Logo MongoDB