I am trying to build an Android app that downloads a space delimited .txt file each time the app is run which is
then imported into an SQlite db so that a query can be run and the data displayed on the app.
Each time the app runs I want the data overwritten with the new .txt file data.
1) What is the best way to retrieve the .txt data file for the app/db to use?
2) How can I import this into a SQlite db? I know that you can use sqlite> .separator ','
sqlite> .import data.txt tablename - on the console, but how do I code this into my app so that it occurs each time
the app is loaded?
I'd be very grateful for any help.