Import SQLite Database From Excel
#writercode #sqlite #database
SQLite database is a database that is physical or does not require a server. So that in its use, we must include the physical file in our project.
So, in this tutorial I will show you how to create a SQLite database file, and enter the excel file as source data.
The following steps:
1. Hello friends, I will show you this video
how to import the sqlite database from the excel file
2. and here, I have an excel file with 1 table and 3 fields
namely code, name and phone that we will import into the sqlite database
3. Before, we need a Mozilla Firefox Firefox add ons
named “Sqlite Manager”
4. If the add ons have been added, we press the “alt” button
on the keyboard, and click the tools menu and select “Sqlite Manager”
5. like this the main view, and first we need
create a database and determine its storage location
6. before we import, we need to save the excel file inside
“CSV” format
7. Now, click the import button, then make sure you select the tab
“CSV” and start looking for the excel file
8. Don’t forget to click the checkbox “First row contains column names”
will be a table field
9. Enter the data type in all fields
10. Finally, we managed to import from the excel file into
sqlite database
====================================
Website :
https://www.tutscode.net
====================================
FanPage Facebook :
https://facebook.com/writercode
====================================
Comments are closed.