Ask Your Question
0

Can I open a ms access file in libreoffice?

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

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
1

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

peterwt gravatar image

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

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
0

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

robaed gravatar image

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

Seen: 16,381 times

Last updated: Oct 09 '18