How to convert data from excel to sqllite database

How to convert data from excel to sqllite database
1.Take the excel sheet where you have your data
2.convert the excel sheet into .csv file(means excel sheet save as .csv file)
3.open sqlite database
4.create database and table
5.create fields in table as excel sheet fields.(names in excel sheet i mean)
6.click import and select the .csv file
7.type the table name(your created) and fill details
8.click OK

Excel sheet is converted into sqlite database

No comments: