Convert csv to db in sqlite

Question

I have a csv file with ; separator. I would like to convert it into .db. I follow advice here: https://www.sqlite.org/cli.html#section_8

In my Ubuntu terminal I use:

Then I try:

.mode list

.separator ";"

.import odberatel.csv odberatel

.save odberatel.db

But When I look on the odberatel.db in Db Browser for SQLite it seems that is not separated correctly:

What do I do wrong, please?

DinoCoderSaurus · Accepted Answer · 2022-01-26 16:25:31Z

1

From the same sqlite doc:

Note that it is important to set the "mode" to "csv" before running the ".import" command.

answered Jan 26, 2022 at 16:25

DinoCoderSaurus

6,5502 gold badges13 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1