I have a database on MS Access with one table containing 25 fields. It contains 1000 to 10,000 or more records (The number of records is an approximation. The company I'm working for has a huge amount of data though).
The company wants to get access to this data (for read-only purposes) on their Android phones. They require this data to be transferred to the phone through a wired connection (no wifi).
Here's how my solution works: I export the MS Access database table as a CSV file. Then, I parse this CSV file using java code, and then insert each record into an SQLite database.
As the records are updated often, we'll have to export a new CSV once every week and refresh the SQLite database.
Here's the issue with my solution:
Takes twice as much storage space: As I understand it, there are two versions of the same table stored on the device - one, as a CSV file, and another as SQLite database.
It requires time to refresh the SQLite database because the 10,000 records need to be deleted and then inserted back.
Someone suggested me to convert the .mdb file into a jar file and run select queries on that jar instead of using SQLite. But I don't understand how it works. Someone please guide me to the right direction.
Aucun commentaire:
Enregistrer un commentaire