Ask Your Question

Importing and creating relationships in base [closed]

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

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 reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-13 06:00:31.481858



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 +0100 )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 +0100 )edit

1 answer

Sort by » oldest newest most voted

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

Christine gravatar image

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

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

Question Tools

1 follower


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

Seen: 446 times

Last updated: Nov 07 '13