Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
Hello,
 
The question is simple: how can i export a MS Access database to a SQLite database, which i will use in Android?
 
Or: is there some way to use an Access database in programming for android? Some libraries for java which can be used on Android system?
 
Thank you for your help!!
Posted 2-Jan-13 7:38am

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

There are quite a few ways to do this.
 
For example, you can write a small application (VB.Net, C#) which connects to the Access Database using OleDb and gets the data to a dataset. After that connect to the SQLite database using for example System.Data.SQLite[^] or OleDb again and insert the data from the dataset to the database.
 
A completely different approach could be to export the data from Access into a CSV file using TransferText[^] and then importing the data into SQLite using SQLite shell, see sqlite - Importing Files[^]
  Permalink  
Comments
janprasil at 4-Jan-13 8:36am
   
Thank you and is there some simple way how to insert the dataset to a sqlite database or must I make schema and insert values myself?
Mika Wendelius at 4-Jan-13 15:08pm
   
In my opinion the best way would be to create the schema beforehand. This way you get all the constraints etc correctly in place.
Member 6522534 at 18-Feb-14 8:52am
   
There is some example or application?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 375
1 RyanDev 135
2 CHill60 120
3 Richard MacCutchan 115
4 Sergey Alexandrovich Kryukov 110


Advertise | Privacy | Mobile
Web02 | 2.8.140709.1 | Last Updated 18 Feb 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid