db.beginTransaction(); String sql = "INSERT INTO stop(atco_code, name, locality, bearing, latitude, longitude) VALUES (?,?,?,?,?,?)"; SQLiteStatement stmt = db.compileStatement(sql); for(StopBean stop : stopList){ stmt.bindString(1, stop.getAtco_code()); stmt.bindString(2, stop.getName()); stmt.bindString(3, stop.getLocality(); stmt.bindString(4, stop.getBearing()); stmt.bindDouble(5, stop.getLatitude()); stmt.bindDouble(6, stop.getLongitude()); stmt.execute(); stmt.clearBindings(); } db.setTransactionSuccessful(); db.endTransaction();