Ask Your Question

microsoft access equivalent in LO?

asked 2018-05-27 21:47:40 +0100

librehous gravatar image

updated 2020-07-11 23:47:51 +0100

Alex Kemp gravatar image

I have an extensive mailing list (~10,000 names) on Microsoft Access in Microsoft Office 2000 on an old PC running Windows XP. I used Access to MailMerge with Word. New computer, a Mac OSX 10.13.4, with LibreOffice. Is there in LibreOffice a program similar to Microsoft Access? If so, how to transfer the information from Access to the LibreOffice program? Can't seem to find this topic in the Document Foundation or FAQs. Thanks.

edit retag flag offensive close merge delete



LibreOffice has the module Base for database usage. Use New > Database to start the wizard. In Windows the drop down "Connection" has an item "Microsoft Access". But the connectors are likely different between Windows and Mac, so I cannot help you further. As long as your old PC works, you should export from Microsoft Access to dBase, to csv and to xls. These formats can be imported in other applications in most cases.

Regina gravatar imageRegina ( 2018-05-28 00:42:26 +0100 )edit

And perhaps you can use the Access2Base library, which is includes in LibreOffice.

Regina gravatar imageRegina ( 2018-05-28 00:50:03 +0100 )edit

2 Answers

Sort by » oldest newest most voted

answered 2018-05-29 01:48:31 +0100

Jim K gravatar image

For best results, install an engine such as MySQL and connect with LibreOffice Base. Embedded databases are quicker to set up but not recommended, as explained at

LO Base is very different from MS Access, so you may need to write SQL queries to move the data from Access into MySQL. Or if the data is simple enough, there are various ways to copy and paste data with a GUI, such as LibreOffice Calc or MySQL Workbench.

edit flag offensive delete link more

answered 2018-10-09 16:20:43 +0100

robaed gravatar image

updated 2018-10-09 16:27:35 +0100

Definitive Answer....Export your MS ACCESS database to .Xls.....what's even "SWEETER" you don't have to even create a table ahead of time to accept the data...Simply Open the .xls in libre calc....copy the data like you see in the video Librebase....then click PASTE....all easy from there

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-05-27 21:47:40 +0100

Seen: 11,184 times

Last updated: Oct 09 '18