Ask Your Question

Can I open a ms access file in libreoffice?

asked 2016-04-29 11:10:37 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I have cd with data from another pc I want to open but I do not have microsoft access on this machine.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted

answered 2016-04-29 11:41:59 +0100

peterwt gravatar image

updated 2016-04-30 10:58:21 +0100

You cannot open a MS Access database in LO Base. You can create a Base database and link to the tables in an Access database. Forms, Reports. and Queries will have to be created in Base.

EDITED 30/04/16

If the Access database was created using Access 2007 or later you can get free from Microsoft the MS Access Runtime program. Thia allows you to open and run a database. You can't modify it in any way. It is efectively Access with all the deaign features removed.

edit flag offensive delete link more

answered 2018-10-09 16:04:39 +0100

robaed gravatar image

updated 2018-10-09 16:28:29 +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: 2016-04-29 11:10:37 +0100

Seen: 23,636 times

Last updated: Oct 09 '18