Click here to Skip to main content
11,935,012 members (51,233 online)
Rate this:
Please Sign up or sign in to vote.
See more: C# VB Access VB.NET SQLite , +

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 8: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 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 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 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
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web01 | 2.8.151126.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