created on Oct 17, 2011 10:16:59 PM
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.
created on Oct 18, 2011 10:06:31 AM
I'll move this to the developer forum where you'll probably have a bit more success. Good Luck!