Ask Your Question
0

microsoft access equivalent in LO?

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

librehous 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

Comments

1

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 +0200 )edit
1

And perhaps you can use the Access2Base library, which is includes in LibreOffice. http://www.access2base.com

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

2 Answers

Sort by » oldest newest most voted
3

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

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 https://wiki.openoffice.org/wiki/FAQ_....

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
0

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

robaed gravatar image

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

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 ...open Librebase....then click PASTE....all easy from there

https://www.youtube.com/watch?v=D_W-F...

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 6,127 times

Last updated: Oct 09 '18