Ask Your Question
0

Is there a way to convert a Microsoft Access file to a LibreOffice format?

asked 2018-10-29 19:52:40 +0200

campsoup gravatar image

updated 2018-10-29 21:30:47 +0200

EasyTrieve gravatar image

I was using Microsoft Office 2007 and i'm now using Libreoffice. I can not find a way to convert an Access database.

edit retag flag offensive close merge delete

Comments

1

What OS are you using & what database will you use in Base?

Ratslinger gravatar imageRatslinger ( 2018-10-29 20:35:44 +0200 )edit

Also, how many data bases, and how big a data base? The reason I ask is there are a variety of strategies.

EasyTrieve gravatar imageEasyTrieve ( 2018-10-29 21:30:18 +0200 )edit

@campsoup, in the future please update your question above to respond to requests for more information here, that is rather than enter an Answer below, ... unless you have an answer. Thanks.

EasyTrieve gravatar imageEasyTrieve ( 2018-10-30 04:05:37 +0200 )edit

2 Answers

Sort by » oldest newest most voted
1

answered 2018-10-30 00:35:03 +0200

Ratslinger gravatar image

Hello,

Make sure you have the proper Java JRE installed for your set-up. See -> on firefox and have loaded java 32

Converting Access to Base will only bring over Tables & possibly Queries. In Windows, there is the ability to connect to an existing database. The selection would be for Access. HOWEVER, this only works for 32-bit LO out-of-the-box. If you are using 64-bit LO please see my answer in this post -> I got error "The connection to the data source "DB file name" could not be established.". There are a couple of possibilities there. This leaves the data in Access with Base as the connection to it. You can then copy the tables from there to another 'pure' base file. Pay attention to data conversion.

Possibly the fastest & easiest method in you case would be to export your Access data to a spreadsheet and then copy that data into a new Base file. Information on this is in this post -> how to convert a ods spreadsheet to and odb table.

edit flag offensive delete link more
0

answered 2018-10-29 23:10:14 +0200

campsoup gravatar image

Windows 10 I have a name and address database in Access. I am not familiar with Base but want to convert the database to a working file in LibreOffice

One database of under 100 names

edit flag offensive delete link more

Comments

1

@campsoup This is not an answer. It should be deleted. Answers are to respond to original question. Instead use add a comment. If more room is needed to explain your question, edit you question with the additional info & identify it as edited information.

Ratslinger gravatar imageRatslinger ( 2018-10-30 00:18:49 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-10-29 19:52:40 +0200

Seen: 216 times

Last updated: Oct 30 '18