Yesterday I wrote a brief post on links to visit for converting your Microsoft Access Database to an OpenOffice Base database. This only works for Windows-based installations.
For those using database formats such as mySQL, Oracle, etc, you should visit MDB Tools.
For some, the best solution might be to open the database on a Windows machine using OpenOffice Base and then convert first prior to moving to a non-Windows machine.
For those that have Microsoft Access databases which they wish to use in OpenOffice, this is now supported. There is a wiki page that will give you more information here, however the most often asked question is answered as per the following:
Can I use Microsoft Access databases (.mdb) in Base?
On Windows: yes. You cannot open them directly via
File|Open, but you can access the data therein. For this, you need the Microsoft Data Access Components, which are available from Microsoft for free. (In Windows XP, they”re already included, so you need them for older Windows versions only.)
For more information on OpenOffice Base, visit the Base FAQs and the main page on OpenOffice Base
My name is Stephanie Krishnan and I'm passionate about the way that open source software and its community can help small businesses and individuals with their productivity and lives. One of the biggest arguments I get from business owners, however, is lack of support options. I decided to put together my own support blog to help people be productive at various levels with one of my favourite open source alternatives: OpenOffice.org! I do this through tutorials, downloadable templates and answers to questions from readers!
