Exporting a database on the phone to a .csv that can be used on the computer

Question

I was wondering whether anyone had the code that would allow me to export my database in my app and export it as a .csv. This would then hopefully allow people to open it in Microsoft Office Excel and read their data at any time.

Have you checked [this](http://stackoverflow.com/questions/2887119/populate-android-database-from-csv-file) — Emmanuel N, Jan 19 '12 at 16:34

braden · Answer 1 · 2013-02-07T18:33:53.067

3

just do SELECT * FROM [table]; (into some datastructure)

FileWriter fstream = new FileWriter("out.txt");
BufferedWriter out = new BufferedWriter(fstream);

for(y=0; y<=[#rows]; y++){
    for(x=0; x<=[#columns]; x++){
        out.write([field]);
        out.write(",");
    }
    out.write("\n");
}
out.close;

edited Feb 07 '13 at 18:33

answered Jan 19 '12 at 16:43

braden

1,496
17
31

I used this. Just need an out.close(); after the for loop. Thanks! – snotyak Dec 02 '12 at 03:31

score 2 · Answer 2 · edited Jan 20 '12 at 19:53

2

Try the following : tutorial

edited Jan 20 '12 at 19:53

kosa

65,990
13
130
167

answered Jan 19 '12 at 16:34

Viking

882
10
16

Thanks very much. I think I can get this to work. I'll give you feedback at a later date when I have it correct. – edwoollard Jan 19 '12 at 16:42

Exporting a database on the phone to a .csv that can be used on the computer

2 Answers2