Best and fastest trick to convert or import MS access to Open ofiice.

Note : As open office base is not so typical as Ms access it only proives some basic functionalities only so if you are trying to pull in VBA coded stuff better not to as it might not work.

There are some procedures that you need to follow to convert an Access dbase file to open office or better Libre office.Previously it was typical to import the dbase file itself but now there are some tricks you can use.

 

Follow this process to import a simple dbase to Open office base.

First of all export your db in CSV or TXT file. To do this simple go to File > Export choose the desired extension.

One dialog box will open where you can adjust delimiter if you want to and then click ok, you can try more than once by adjusting these options in case your import.

Now create a new database to do so Choose File > New > Database. Don’t change any thing visit directly this window.

Now simply open the previously made spreadsheet in csv format and copy paste it,choose all the data you want to bring in. Now click the tables icon and right click in the table area and choose paste. Now follow the wizard. Give a name to table and don’t touch anything else except the primary key field if you don’t have any.Click >> button to add them all.Now recheck and click create and your table will now appear in the database.

Connect MS access with OOoBase

As the other objects like macros and forms of both the software’a are incompatible it is not easy to convert MS Access DB to OpenOffice.Base but still you can try to connect them to do so here is an simple official article provided in pdf format.

Download pdf file by click here

 

Opening Ms access File Using database wizard

 

You can even try this method first of all export your database tables as csv format and put them in a separate folder and after opening the OOo software’s you can create a new dbase and select “Connect to an existing database”, and choose the text format now when the next screen will appear you have click on browse and choose that cSV file folder now in wizard it will ask you to either importing plain text files or comma separated values file. Go for “Comma separated values”.

You have to make sure that field separator / decimal separator is set properly otherwise data might appear haphazardly.Though you can try multiple times to make sure it looks ok. Click next and finish.

Access2Base convertor or importer : This tool works a bit like Ms VBA that means it is a basic library of macros for LibreOffice/OpenOffice. It is a tool that can be used to migrate MSAccess applications to Base. It will be better if you try some examples out there. Download here