Android Database Table export to CSV – Part 1


The best way to export data out of Android Sqlite database is create a copy the DB file into the SDCard.

Copy the Android database into DB File –

Advantages –

  • The import and export of the database would be a lot easy.
  • All tables could be backed up using a single file. ( This can have the backup of the user defined configuration of the program also ).

Disadvantages –

  • We need special tools to read this DB file which makes it difficult to be portable.

Copy a table into CSV file –

Advantages –

  • Only data required by the user can be given.
  • It is the more readable and portable format.

In my application I have decided to have both this methods. Will be updating soon.

Advertisements

One Response

  1. […] Android Database Table export to CSV – Part 1 […]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: