SQLite Import Text File into SQLite database as a table

This is a short video to demonstrate how to import table from a flat file / text file into SQlite database.

Sqlite3
.mode csv
.separator ” ” [Default is comma]
.import customers.txt customers
.tables
.schema
.SELECT * from customers
.exit