csv import (800 megs) to sqlite?

Question

SQLite

I am interested in such a question, there is a text file in csv format separated by commas, the file size is 800 megabytes, it needs to be converted to sqlite, I tried a lot of programs, but they either hang or write that there is not enough memory, although RAM is 8 gigabytes + 4x core processor, the only thing what happened, import this database into access, but unfortunately I didn’t find export to sqlite there. Yes, here's another, is there a text editor that can open such a large file for editing? I tried FAR (writes in red letters - out of mem), notepad ++ (swears right away).
Maybe someone came across this and decided, I would be grateful if you help, thanks in advance!

Answer 1

Navicat has an excellent Import Wizard. We select Text File there, put a comma in the field delimiter (for csv) and that's it. If required, it will even create the table structure for the imported data itself.
PS Navikat has a free version, but I'm not sure if this wizard is there.

Answer 2

UltraEdit can open files of any size (see configuration in File Handling -> Temporary Files -> Open file without temp file).

Answer 3

Use mysqlimport, it drives CSV into MySQL very quickly, and from there it is already in SQLite with a query, I think you can handle it.