Created at 2014-03-13 Updated at 2023-03-08 - 1 min. read Category work
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)
First save your .XLS file into .CSV
just save save as your .xls file into .csv format
DOWNLOAD SQLite manager plug-in for FIREFOX
after that open SQLite manager from TOOL tab in firefox.
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.