Android SQlite Help

  • Replies:1
  • OpenNot stickiedUnanswered
  • Forum posts: 1

Oct 17, 2011 10:16:59 PM via Website


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.