Importing CSV file to android sqlite datase on phone itself

Asked Jun 19 '14 at 13:46

Active Jun 19 '14 at 14:13

Viewed 33 times

I am trying to import a CSV file into android database. I tried inserting the csv file line by line ( myDB.insert(DATABASE_TABLE, null, values) command), but it was very slow.

One of the alternatives provided on net was to convert csv to sqlite on computer itself, and then copy it.

But the app requires to import csv files only, and I have seen apps on Google-play that do the same pretty fast.

Also the CSV table is not static so storing it in assets folder and importing is not an option. And, somewhere it was mentioned that Insert Helper is deprecated from version 17, so probably it should also not be used.

Please Help.

edited Jun 19 '14 at 14:13

asked Jun 19 '14 at 13:46

chyle

This is a [FAQ](http://www.sqlite.org/faq.html#q19). – CL. Jun 19 '14 at 13:51
@CL. could you please tell a link, as I was unable to find any solution. – chyle Jun 19 '14 at 14:09
The answer tells you to use a single transaction. – CL. Jun 19 '14 at 14:14

Importing CSV file to android sqlite datase on phone itself

0 Answers0