how to convert access mdb db to sqlite db

Question

2.00/5 (1 vote)

See more:

Hi all of you,

I have created one application in vb.net and i am used mdb database.
It works fine there is no any problem in that application.

I want to convert all mdb table or data in that database to Sqlite.
In my database there are 3 lakh above record it take some time to load data in database.
for fast searching the data i want to convert the Mdb to sqlite.

Is it possible then give me reply..
Thanks in Advance.

Posted 30-Jun-14 2:24am

basurajkumbhar

Updated 12-Aug-22 17:24pm

Add a Solution

2 solutions

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)

CHill60 · Answer 1 · 2014-06-30T03:51:00

There are products out there that claim to do this conversion for you, but you can do it for free by exporting the Access tables to CSV format and then using the SQLite shell[^] to import them into tables on SQLite.

I would suggest creating the tables on SQLite first to ensure that dates are interpreted as dates, ints as ints etc rather than relying on the import to determine what the data types are.

Don't add any indexes to the tables until after you have imported them.

With either Access or SQLite choose appropriate indexes to search the database(s) faster.

It will take some time to export then load but it only needs to be done once.

Just went to the SQLite site to check on something and also found this link to their converter[^]. It claims to read from Access also.

just_123 · Answer 2 · 2022-08-12T17:24:00

Solution 2

I did it with this Python code (link attached)

Posted 12-Aug-22 17:24pm

just_123

Updated 12-Aug-22 18:19pm

v2

Comments

OriginalGriff 13-Aug-22 0:20am

While I applaud your urge to help people, it's a good idea to stick to new questions, rather than 8 year old ones. After that amount of time, it's unlikely that the original poster is at all interested in the problem any more!
Answering old questions can be seen as rep-point hunting, which is a form of site abuse. The more trigger happy amongst us will start the process of banning you from the site if you aren't careful. Stick to new questions and you'll be fine.

just_123 13-Aug-22 2:32am

google search sometimes lead to this topic - answer could not harm to any new researchers when all necessary & tested codes are in one place. I just cared about the fullness of the topic when answering. If I cared only about reputation (from my first post here) I would answer day-to-day questions. But just decided to share working case with a Community -- I don't think it is forbidden, & I don't understand your agressive banning warning in such a case.