SQLite delivers mechanism to import data from another source. One of this source is CSV file.
For import data You launch sqlite3 engine. Open or create new database.
In my one of last posts I decribed how export data from SQL Server to CSV file:
Export data from SQL Server to CSV file
My file fof data is
region.csv , which contains data from
First step is to create table for these data.
create table region(id_region int PRIMARY KEY,nazwa_region varchar(100)NOT NULL);
.import region.csv region
.import command You must write path or only name of file ( it is differ from location of file ) and after name of file – name of table for data.
SELECT query You may see your data in
region table in SQLite.