Exporting SQLite Database to csv file in android

by

Thanks for your suggestions guys which led me to this answer:

private void exportDB() {

        DBHelper dbhelper = new DBHelper(getApplicationContext());
        File exportDir = new File(Environment.getExternalStorageDirectory(), "");
        if (!exportDir.exists())
        {
            exportDir.mkdirs();
        }

        File file = new File(exportDir, "csvname.csv");
        try
        {
            file.createNewFile();
            CSVWriter csvWrite = new CSVWriter(new FileWriter(file));
            SQLiteDatabase db = dbhelper.getReadableDatabase();
            Cursor curCSV = db.rawQuery("SELECT * FROM contacts",null);
            csvWrite.writeNext(curCSV.getColumnNames());
            while(curCSV.moveToNext())
            {
                //Which column you want to exprort
                String arrStr[] ={curCSV.getString(0),curCSV.getString(1), curCSV.getString(2)};
                csvWrite.writeNext(arrStr);
            }
            csvWrite.close();
            curCSV.close();
        }
        catch(Exception sqlEx)
        {
            Log.e("MainActivity", sqlEx.getMessage(), sqlEx);
        }
}

More Related Contents:

  1. Import .csv file to Sqlite in Android
  2. How to implement Export sqlite To excel/csv file in android?
  3. Android SQLite data display to ListView
  4. IN clause and placeholders
  5. Android Database Transaction
  6. Best place to close database connection
  7. Backup and restore SQLite database to sdcard
  8. Permission Denial: this requires android.permission.INTERACT_ACROSS_USERS_FULL
  9. How to split comma-separated value in SQLite?
  10. Cursor adapter and sqlite example [closed]
  11. How to insert a SQLite record with a datetime set to ‘now’ in Android application?
  12. How to retrieve data from sqlite database in android and display it in TextView
  13. Bulk Insertion on Android device
  14. Android Sqlite selection args[] with int values
  15. SQLite simultaneous reading and writing
  16. update sql database with ContentValues and the update-method
  17. SQLiteDatabase close() function causing NullPointerException when multiple threads
  18. Using the LIMIT statement in a SQLite query
  19. sqlite encryption for android
  20. Android quotes within an sql query string
  21. Android SQLite rawquery parameters
  22. Saving ArrayLists in SQLite databases
  23. How to convert milliseconds to date in SQLite
  24. DB File in Assets Folder. Will it be Updated?
  25. Backup/restore sqlite db in android [duplicate]
  26. How to store JSON object in SQLite database
  27. sqlite3: not found
  28. Android SQLiteOpenHelper cannot open database file
  29. Getting the type of a column in SQLite
  30. Android table creation Failure (near “autoincrement”: syntax error)?

Leave a Comment