Import .CSV files onto SQLite

Question

Hello, I am having some problem in importing a .csv file into a sqlite table. My .csv file looks like this Name,Age,, Hamish,27,, Praveen,27,,

There are no trailing spaces anywhere. I create a table in the 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". Probably something to do with the delimiter. Any ideas?

Answer 1

Make sure you specify the delimiter, and do so without quotes:

.separator ,