Click here to Skip to main content
15,077,931 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

1 solution

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.
   
Comments
basurajkumbhar 2-Jul-14 1:23am
   
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 ...

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