SQLITE

Created at 2014-03-13 Updated at 2024-11-07 - 1 min. read Category work Tag android / conversion / database / sqlite

While working on a project of android.i came to clash with DATABASE thing.

i was having .xls file problem was how to convert it to a .sqlite(android database file)

STEP 1
First save your .XLS file into .CSV

just save save as your .xls file into .csv format

STEP 2

DOWNLOAD SQLite manager plug-in for FIREFOX

STEP 3

RESTART firefox.

after that open SQLite manager from TOOL tab in firefox.

STEP 4

In SQLite manager.

Create NEW DATABASE.

select IMPORT option from database tab

select your .csv file location

your SQLite database is ready where you have saved it while creating your DATABASE.
It would be with the name databasename.sqlite
now just insert it in your code.

THANK YOU