Hand entering data is great if you’re collecting your own data and need to enter it yourself, but it’s a pretty terrible way to use already available data, especially if it’s more than a few dozen lines long. This example will walk you through how to get data that already exists into SQLite.
New Database
in the Database
drop down menu. Select a file name, like portal_mammals.sqlite
, and location.
Import
icon.
Select File
and navigate to where you saved the data file
and select it.
CSV
. You’ll notice that you can also import from other SQL or
modify the Fields separated
or enclosed by
. You’ll want to make sure to
select First row contains column names
.
OK
when it asks if you want to modify the data.Surveys
.Data Type
drop-down menus. If
it is not obvious if the data type is an INTEGER
or VARCHAR
for each
variable, check the metadata. Important: if you specify the wrong data type it
can cause some data to not be imported and/or prevent you from doing some kinds
of data manipulations. recordID
as the Primary Key
and click OK
.OK
when it asks if you are sure you want to import the data.