How to export a MS Access database to a SQLite database? (vb.net\c#)

Question

0.00/5 (No votes)

See more:

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

janprasil

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Wendelius · Answer 1 · 2013-01-02T08:23:00

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

Posted 2-Jan-13 8:23am

Wendelius

Comments

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?

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.

Robert Marck 18-Feb-14 8:52am

There is some example or application?