Import .CSV files to SQLite

Question

I had a problem importing a CSV file into sqlite table. My. The CSV file looks like this:

Name,Age,,
Hamish,27,,
Praveen,27,,

There are no trailing spaces anywhere. I create a table in SQLite db with the same schema, but when I run .import... it shows me an error saying "expected 2 columns of data, but found 1". Maybe something to do with the delimiter. Any ideas?

Answer 1

Make sure you specify the delimiter and do this without quotes:

.separator ,