Amazon Great Offers

September 16, 2013

Convert MS-Access to SQLite Database

If you are familiar with MS-Access database creation and wants to covert your database to SQLite without putting all your efforts again.

If you database already exists in MS-Access and you want to have that in SQLite for mobile development. Its now a cake-walk like conversion

Here is an easy process to do that.

 

  • Download from https://code.google.com/p/mdb-sqlite/downloads/list
  • Extract the file, you will be getting mdb-sqlite folder with below file structure
  • image
  • Open Command Prompt and navigate to mdb-sqlite folder
  • Run “ant dist” command (without quotes")
  • image
  • Once the build successful, it will generate dist\main.jar and dist\mdb-sqlite.jar files
  • You can use these jar files to covert your ms-access database to sqlite database with the following command
  • Syntax :-
    • java -jar dist\mdb-sqlite.jar source.mdb output.sqlite
  • Example :-
    • java –jar dist\mdb-sqlite.jar employee.mdb employee.sqlite

 

References

https://code.google.com/p/mdb-sqlite/

Blogger Labels: Convert,SQLite,Database,creation,efforts,Here,Download,code,Extract,folder,Open,Command,Prompt,quotes,Once,files,Syntax,output,Example,employee,References,google,dist,java
Post a Comment

Featured Post

Java Introdcution

Please send your review and feedback to psrdotcom@gmail.com