Python Forum

Full Version: convert text to sqlite3
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
I am looking for a way to read texxt file then convert into database(sqlite3).
any recommended materials?
csv module and sqlite3 module from standard library

of course knowledge to work with files is presumed.
(Apr-10-2018, 12:57 PM)buran Wrote: [ -> ]csv module and sqlite3 module from standard library

of course knowledge to work with files is presumed.

U mean txt can be process like csv?
Quote:U mean txt can be process like csv?
cvs can be processed as text, because it is text.
Text would have to be comma delimitered in order to be processed as cvs.
(Apr-11-2018, 03:56 AM)Larz60+ Wrote: [ -> ]Text would have to be comma delimitered
Have to be delimited, you can specify the delimiter
Yes, of course.