Convert Access Database to SQLite
Converting a database:
I found this to be the best (and easiest) tool:
This took a 440 MB file in Access down to a 80 MB file (although, it should be noted the demo version only saves half the table data; still, assuming the other half is 80 MB, we see a huge reduction in file size).
Also I like that this goes to an open access file format. With SQLite3 in the command line, or SQLite Studio across platforms, a file format that was once proprietary and accessible only to those with Windows software is now an open -access format.
I’ll update this post with examples at a later point.
Other options I evaluated:
- This one did not work for me, although I appreciated that it’s open source. I don’t think it works with sqlite 3.
- Also, it appears to work for .mdb only; you have to convert an .accdb file to a .mdb file