Android SQlite Help

  • Replies:1
Philip M.
  • Forum posts: 1

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

Hi,

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.

Reply
Aaron Tilton
  • Forum posts: 838

Oct 18, 2011, 10:06:31 AM via Website

I'll move this to the developer forum where you'll probably have a bit more success. Good Luck!

Reply