Click here to Skip to main content
11,642,381 members (62,695 online)
Rate this: bad
Please Sign up or sign in to vote.

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
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[^]
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)

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

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100