To insert large amount of data in android SQLite Database

Question

I am new in Android Development.

Currently, working with SQLite Database in Android.

My problem is that I have a large amount of data which I have to store in SQLite Database in Android.

There are 2 tables: One having 14927 rows and the other one has 9903 rows.

Currently the database in sql. And I have copy these data in excel sheet but don't understand how can I import these data in SQLite Database.

I go through the following link:

Inserting large amount of data into android sqlite database?

Here, the solution is posted regarding CSV File. But want to know other ways of doing this.

Please let me know what is the best way to import such a large data in Android.

Please help me. Thanks in advance.

Answer 1

Do Like This

SQLiteDatabase sd;
    sd.beginTransaction();


        for (int i = 0; i < data.size(); i++) {
            ContentValues values = new ContentValues();
            values.put(DBAdapter.Column1,  "HP");
            values.put(DBAdapter.Column2,  "qw");
            values.put(DBAdapter.Column3,  "5280");
            values.put(DBAdapter.Column4,  "345, 546");
            sd.insert(DBAdapter.TABLE, null, values);
            sd.insertWithOnConflict(tableName, null, values, SQLiteDatabase.CONFLICT_IGNORE);

        }

    sd.setTransactionSuccessful();
    sd.endTransaction();