android - Copying records from MS Access database into SQLite database using CSV format. Need an alternative -


i have database on ms access 1 table containing 25 fields. contains 1000 10,000 or more records (the number of records approximation. company i'm working has huge amount of data though).

the company wants access data (for read-only purposes) on android phones. require data transferred phone through wired connection (no wifi).

here's how solution works: export ms access database table csv file. then, parse csv file using java code, , insert each record sqlite database.

as records updated often, we'll have export new csv once every week , refresh sqlite database.

here's issue solution:

  1. takes twice storage space: understand it, there 2 versions of same table stored on device - one, csv file, , sqlite database.

  2. it requires time refresh sqlite database because 10,000 records need deleted , inserted back.

someone suggested me convert .mdb file jar file , run select queries on jar instead of using sqlite. don't understand how works. please guide me right direction.


Popular posts from this blog