Click here to Skip to main content
15,437,139 members
Please Sign up or sign in to vote.
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
Updated 12-Aug-22 17:24pm

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.
 
Share this answer
 
Comments
basurajkumbhar 2-Jul-14 1:23am     CRLF
Thanks For Reply. I appreciate your reply. I want only do data fetching goes to fast, If there is any way to show the data immediately. Please give me reply. Once again thanks ...
I did it with this Python code (link attached)
 
Share this answer
 
v2
Comments
OriginalGriff 13-Aug-22 0:20am     CRLF
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.

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900