For the first command the first row of the file contains duplicate column names. For the second set of commands you forgot to set .mode csv If the first row contains unique column names then you can import the file with: ``` .mode csv .separator ; .import file table ``` If the first row of your SSV file does not contain unique column names then you must define the table to import the data into first then do the same commands: ``` create table t (...); .mode csv .separator ; .import file t ``` Are you sure you are using a version of SQLite that supports using different separator characters?