How to export sqlite database as csv file in android?

Question

i am trying to print the content's in the table from the database .so i am trying to generate a csv file from database.. any inputs on how to do this always appreciated

jkhouw1 · Accepted Answer · 2011-05-28 10:38:11Z

2

copy the db to your local computer. use sqlite3 to query and redirect the output to a text file.

sqlite> .mode list
sqlite> .separator ,
sqlite> .output test_file_1.txt
sqlite> select * from yourtable;
sqlite> .exit

http://www.sqlite.org/sqlite.html

answered May 28, 2011 at 10:38

jkhouw1

7,3354 gold badges34 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to export sqlite database as csv file in android?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related