Ask Your Question

Importing and creating relationships in base

asked 2013-08-12 19:09:42 +0200

Jukeday gravatar image

So I have an .xlsx file I need to import into Base. It has two tables and I need to create a relationship between the two tables. I can import the file just fine by opening it in Calc first, saving it, then connecting to it when I open Base. However, when I try to create a relationship I get the error "This database does not support relations."

What do I need to do? What am I doing wrong?

edit retag flag offensive close merge delete



Perhaps you should save it as LO Base file? If you, somehow, open LO Calc file in Base, Calc file does not support relationship as does LO Base file.

Ljiljan gravatar imageLjiljan ( 2013-08-12 20:52:18 +0200 )edit

I am having the same issue as well. This advice doesn't solve the problem for me. I recreated my XLSX as a ODS file, imported it into Base and got all the tables. But when I try to run a join or add a relationship, I am not able to because of the same error above.

Christine gravatar imageChristine ( 2013-11-07 17:55:56 +0200 )edit

1 answer

Sort by » oldest newest most voted

answered 2013-11-07 18:48:22 +0200

Christine gravatar image

updated 2013-11-07 18:48:59 +0200

Hi there, I had the same problem. I found my answer here:

It's not that the relations can't be done, it's that something goes wrong with the import process, so copying and pasting the tables over helps.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2013-08-12 19:09:42 +0200

Seen: 252 times

Last updated: Nov 07 '13