Access Database Converter

An online open source Microsoft Access database converter

June 20, 2017
In category Tools
Converts the database to JSON text file format (.json) with UTF-8 encoding
Converts the database to a MySQL dump file (.sql) that it can be imported to a MySQL database.
Tested with MySQL server 5.7 (not tested with older version and may result to failed imports)
Converts the database to SQLite Version 3 file format (.sqlite3)
Conversion finished successfully. Use the link below to download the file.
Download

About

This is an online Microsoft Access database conversion tool to convert old and new Access database formats to some other popular databases and formats. It is built with Jackess, a Java library for reading and writing MS Access databases. It supports Access 97 and all versions 2000-2013.

MS Access was the first database I got my hands on when I began writing code. I have some old projects using Access databases that I want to rebuild, or just get the old data to port to some other environments. I even have some clients with systems using old Access databases that sometimes is needed to be converted to process and use all the data. So, I built up this online tool to have it anytime and for everyone to use it.

Exports

It currently exports MySQL dump file, SQLite and JSON. All result files are compressed with GZip to zip archive files. It does support primary index auto increment keys, but it does not export secondary and other unique keys and that’s a todo feature that I will work on sooner or later.

About the data

All files uploaded are deleted immediately after conversion. All files generated are deleted after an hour of their creation, so all the links generated will work for just an hour.

Bugs

Please report any bugs or features you may want, by using the Contact Form on this blog.

Open source

Wednesday 6th of September 2017

I have released the source code and binaries of the Java application on Github under MIT License.

Github repo: https://github.com/clytras/AccessConverter

Sourceforge project: https://sourceforge.net/projects/accessconverter/

0 0

comments powered by Disqus