Click here to Skip to main content
11,576,977 members (59,364 online)
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 Sergey Alexandrovich Kryukov 221
1 DamithSL 155
2 OriginalGriff 155
3 Abhinav S 130
4 Afzaal Ahmad Zeeshan 95
0 OriginalGriff 820
1 Sergey Alexandrovich Kryukov 631
2 Abhinav S 528
3 F-ES Sitecore 420
4 Suvendu Shekhar Giri 365


Advertise | Privacy | Mobile
Web04 | 2.8.150603.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